MAXDB / SAPDB MAPCHARSET UNICODE Problem Solution :)))

You can define UNICODE MAPCHARSET's for your own
locales.

Here are the steps:

1 ) Find the UNICODE HEXADECIMAL codes for characters
that you want to add to MAPCHARSET. You must also find
the HEXADECIMAL code of the CHARs that lies before the
LOCALE CHARS like C for  Ç or O for Ö etc.

 For TURKISH :
C       x'0043'         
Ç       x'00C7'
G       x'0047'         
Ð       x'011E'
I       x'0049'         
Ý       x'0130'
O       x'004F'         
Ö       x'00D6'
S       x'0053'         
Þ       x'015E'
U       x'0055'         
Ü       x'00DC'

2) Now we must create the conversion map

Char conversion for Turkish

x'00C7' TO x'004300FF', means Ç processed as C +
char(255)
x'011E' TO x'004700FF',
x'0130' TO x'004900FF',
x'00D6' TO x'004F00FF',
x'015E' TO x'005300FF',
x'00DC' TO x'005500FF',


3 ) create the script 

for UPPER CASE TURKISH CHARS

CREATE MAPCHAR SET TRMAP AS UNICODE WITH x'00C7' TO
x'004300FF',x'011E' TO x'004700FF',x'0130' TO
x'004900FF',x'00D6' TO x'004F00FF',x'015E' TO
x'005300FF',x'00DC' TO x'005500FF

4 ) Open DATABASE MANAGER make your DB ONLINE than
goto INSTANCE / Commandline Menu Command

Write "util_execute CREATE MAPCHAR SET TRMAP AS
UNICODE WITH x'00C7' TO x'004300FF',x'011E' TO
x'004700FF',x'0130' TO x'004900FF',x'00D6' TO
x'004F00FF',x'015E' TO x'005300FF',x'00DC' TO
x'005500FF"
 than enter

Now you have the UNICODE MAPCHARSET.

Usage:

Select * from USERS order by MAPCHARSET(ADI,TRMAP)

This SQL sorts the data in USERS Table in Turkish
Collating Sequence

Note :

Your database must be UNICODE as default 


Have a nice QUERIES :)))

RAO & Nadir






                
__________________________________ 
Do you Yahoo!? 
Meet the all-new My Yahoo! - Try it today! 
http://my.yahoo.com 
 


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx