This question was asked in May 2003, but I would like to know if SAP DB supports now UTF-8 encoding ?
Well, some people think that the worls needs UCS4 for storing unicode-string because the unicode-table has growen that big.
So which are you using to access SAPDB? Java for example does only support UCS2 too.
If not, and because I suppose that it is not possible to transform UTF-8 to UCS2, I am thinking about recording strings as VARCHAR(%n) BYTE. What do you think about this idea ?
It possible to transform UCS2 to UTF-8, but if you try to convert UTF-8 to UCS2 you will loose all chars with a code geater than 65535. That are not many as far as i know. only some chars of languages that are rarely used. I think you don't have to worry about using UCS2.
I wouldn't like to see Byte-Strings stored in the DB since you won't find any frontend that supports it out of the box.
BTW: PostgreSQL is a database that uses UTF-8 internally to store Strings, but if you acces those fields via ODBC for example, you will find out that ODBC uses WCHAR (2byte) which means that the ODBC-driver has to convert everything to UCS2 :-)
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
