I have problem creating a mapcharset

[Former Member]

Hello,

I need to sort my query results according to Czech alphabet so I am trying to create a mapcharset.

No matter what I enter as a map_code for a characters, the database changes 2nd byte of map_code to SPACE ( x'20')

Can anybody help me please

Thanks

Richard Silhan

[Former Member · Accepted solution]

Bug was found. Thank you for helping us.

Perhaps you will succeed if you do not specify the exchange-value as hex-literal, but as a normal string-literal.

util_execute CREATE MAPCHAR SET Z_CZWIN1250 AS ASCII WITH X'8A' to 'Se', X'8D' to 'Te'

That worked for me.

Good luck and please excuse the inconveniences.

Elke

[Former Member · Accepted solution]

You are right,

that works for me too. So many thanks and have a relaxing

weekend

Richard

[Former Member]

Hi,

I was quite sure having asked the following, but as it is not written in here, I will do it now (in case you still need help concerning this thread):

are we talking about a UNICODE-database, meaning: the installation parameter

_UNICODE is set to YES?

How does your command to create the mapcharset looks like?

Which MaxDB version are we talking about?

Elke

[Former Member]

Hi,

sorry for a delay, I was rather busy and this problem isn't now at the top of a todo list.

Nevertheless I would like to know how does this work. So here are my answers.

MaxDB version 7.6, installed with _UNICODE set to YES

Here is part of a command to create mapcharset

util_execute CREATE MAPCHAR SET Z_CZWIN1250 AS ASCII WITH X'8A' to X'5365', X'8D' to X'5465'

Have I missed something? Can I create ASCII mapcharset in UNICODE db?

Thanks for your help

Richard