-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]