-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Tuesday 02 September 2003 1:36 pm, Morten Gulbrandsen wrote:
> mysql> SET @s = CONVERT('ABC' USING ucs2);
> ERROR 1115: Unknown character set: 'ucs2'
> mysql>
It works for me. I think you need to be using mysql 4.1.1alpha from BK.
see: http://www.mysql.com/doc/en/Installing_source_tree.html
mysql> SET @s = CONVERT('ABC' USING ucs2);
Query OK, 0 rows affected (0.09 sec)
...
[EMAIL PROTECTED] simon $ mysql_alpha --version
mysql_alpha Ver 14.1 Distrib 4.1.1-alpha, for pc-linux (i686)
> the manual has some statement about ucs2 :
> Temporary restriction:
> UCS-2 can't (yet) be used as a client character set. That means that
> SET NAMES ucs2
>
> will not work.
>
> Can I please have an example how to utilize this ?
I use latin-1 as my client character set and add all my UCS2 data in hex.
Example:
INSERT INTO foo (ucs2text,num) VALUES (_ucs2 x'006300610074', 123);
^^ Adds the text "cat" into ucs2text, and 123 into num...
There may be more graceful ways of doing this. Also, I am having trouble
making wildcards work using this method. For example... If I ran the above
SQL, then:
SELECT * FROM foo WHERE ucs2text LIKE "cat" ;
return a result, but:
SELECT * FROM foo WHERE ucs2text LIKE "ca%" ;
does not.
- - Simon
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
iD8DBQE/VJ0XPBt+tvwCnbYRAqLYAJ4gz3a5DISd28RETk+vaperus8xKwCfdsUN
nryG0WzFwcJ5QZiUwy4nPcE=
=NhU+
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
