-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wednesday 27 August 2003 12:05 pm, I wrote:

> How do I escape UCS2 characters in a latin1 SQL statement?

Okay, so the answer's in the manual. I just didn't look hard enough...
http://www.mysql.com/doc/en/Charset-literal.html

So I do:
 'INSERT INTO blahblah (ucs2col,etc) VALUES (_ucs2 x'0024003100300030', 123)'

ta-daa.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/TLzDPBt+tvwCnbYRAke2AJ9dMWEt4ggMApR0Nsln85ZlkQylTgCfa/sk
+Mm5jDSavr2PTyi/UavJcAI=
=OxZs
-----END PGP SIGNATURE-----


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to