sqlite_udf_encode_binary(3) [php man page]

SQLITE_UDF_ENCODE_BINARY(3)											       SQLITE_UDF_ENCODE_BINARY(3)

sqlite_udf_encode_binary - Encode binary data before returning it from an UDF

SYNOPSIS

       string sqlite_udf_encode_binary (string	$data)

DESCRIPTION

       sqlite_udf_encode_binary(3)  applies  a	binary	encoding to the $data so that it can be safely returned from queries (since the underlying
       libsqlite API is not binary safe).

	If there is a chance that your data might be binary unsafe (e.g.: it contains a NUL byte in the middle rather than at the end,	or  if	it
       has and 0x01 byte as the first character) then you must call this function to encode the return value from your UDF.

	PHP does not perform this encode/decode operation automatically as it would severely impact performance if it did.

       Note

	       Do  not	use  sqlite_escape_string(3)  to  quote  strings  returned  from  UDF's as it will lead to double-quoting of the data. Use
	      sqlite_udf_encode_binary(3) instead!

PARAMETERS

	      o $data
		- The string being encoded.

RETURN VALUES

	The encoded string.

SEE ALSO

       sqlite_udf_decode_binary(3), sqlite_escape_string(3), sqlite_create_function(3), sqlite_create_aggregate(3).

PHP Documentation Group 											       SQLITE_UDF_ENCODE_BINARY(3)

base64(n)					       Text encoding & decoding binary data						 base64(n)

__________________________________________________________________________________________________________________________________________________

NAME

       base64 - base64-encode/decode binary data

SYNOPSIS

       package require Tcl  8

       package require base64  ?2.4?

       ::base64::encode ?-maxlen maxlen? ?-wrapchar wrapchar? string

       ::base64::decode string

_________________________________________________________________

DESCRIPTION

       This package provides procedures to encode binary data into base64 and back.

       ::base64::encode ?-maxlen maxlen? ?-wrapchar wrapchar? string
	      Base64  encodes  the  given  binary string and returns the encoded result. Inserts the character wrapchar every maxlen characters of
	      output. wrapchar defaults to newline. maxlen defaults to 60.

	      Note well: If your string is not simple ascii you should fix the string encoding before doing base64 encoding. See the examples.

	      The command will throw an error for negative values of maxlen, or if maxlen is not an integer number.

       ::base64::decode string
	      Base64 decodes the given string and returns the binary data.  The decoder ignores whitespace in the string.

EXAMPLES

       % base64::encode "Hello, world"
       SGVsbG8sIHdvcmxk

       % base64::encode [string repeat xyz 20]
       eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6
       eHl6eHl6eHl6
       % base64::encode -wrapchar "" [string repeat xyz 20]
       eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6eHl6

       # NOTE: base64 encodes BINARY strings.
       % set chemical [encoding convertto utf-8 "Cu2088Hu2081u2080Nu2084Ou2082"]
       % set encoded [base64::encode $chemical]
       Q+KCiEjigoHigoBO4oKET+KCgg==
       % set caffeine [encoding convertfrom utf-8 [base64::decode $encoded]]

BUGS, IDEAS, FEEDBACK
       This document, and the package it describes, will undoubtedly contain bugs and other problems.  Please report such in the  category  base64
       of the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883].  Please also report any ideas for enhancements you may have for
       either package and/or documentation.

KEYWORDS

       base64, encoding

COPYRIGHT

       Copyright (c) 2000, Eric Melski
       Copyright (c) 2001, Miguel Sofer

base64									2.4								 base64(n)