Not natively (i.e. you can't sort on a Unicode field, for example), but you can still store Unicode text in fields. Just use a BLOB or you can even use VARCHAR(), et al, but remember that you only get half as many Unicode characters as you specify in the field width...
If you're using the native mysql API, you've also got to remember to escape all your text properly (i.e. cast it to a char * and convert any NULs to "\0", etc). Some of the other APIs out there (JDBC or ODBC, etc) might have better binary support (i.e. you might not have to worry about it for them, just give a data pointer and field length to them) but I don't use them, so I'm not sure... Also realise that almost all the client tools out there don't recognise Unicode and so will only display the first character of your string (or something similar, depending on what's actually stored in the string). My application uses Unicode for almost everything (though I don't need to sort on any text fields so it's OK) and I've not had any problems... Dean Harding. -----Original Message----- From: toby - [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 19 June 2002 5:13 pm To: [EMAIL PROTECTED] Subject: mysql and unicode .... does mysql 32.23.51 support unicode ???? thnx a million ... toby ..... _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
