Den Thu, 06 Feb 2003 15:27:51 +0100 skrev Łukasz Borzęcki: > Hi, > > I need to edit mapchar set to properly sort entries in polish. I have done > this on my test database and everything worked fine. > But now i want to transfer the mapchar set to another database. I have > created SQL statment, saved it in file and executed in SQL Studio for new > database but i have got the following error: > > Statement ( shortened): > CREATE MAPCHAR SET pol AS ASCII WITH X'A1' TO X'2120', X'BF' TO X'3F20', > X'C0' TO X'4120', X'C1' TO X'4120', X'C2' TO X'4120', X'C3' TO X'4120', > X'C4' TO X'4165', X'C5' TO X'4161', X'C6' TO X'4165', X'C7' TO X'4320', > X'C8' TO X'4520', X'C9' TO X'4520', X'CA' TO X'4520', X'CB' TO X'4520', > X'CC' TO X'4920', X'CD' TO X'4920', X'CE' TO X'4920', X'CF' TO X'4920', > X'D0' TO X'4420', X'D1' TO X'4E20', X'D2' TO X'4F20', X'D3' TO X'4F20', > X'D4' TO X'4F20', X'D5' TO X'4F20', X'D6' TO X'4F65', ... > > > Error message: > Syntax error or access violation -5015 POS(8); Missing keyword: TYPE, > TRRIGER, SEQUENCE, ROLE, PACKAGE, VIEW, USERGROUP, USE. > > How should I transfer my mapchar set to another database? > > The above example is for ASCII database, but what should I do to achieve > proper sorting of polish characters in UNICODE database? > > Regards > Łukasz Borzęcki
I'm pretty sure you can't use mapchar sets in UNICODE, mainly because you don't need them. I don't think the reason you have mapchar sets in ASCII is for sort orders, but rather to be able to store certain characters alltogether. Using UNICODE you can already store all characters. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
