Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Special Slovenian characters in database

2 posts in Xbase++ Last posting was on 2008-02-06 10:29:35.0Z
Toma? Grom Posted on 2008-02-04 13:34:32.0Z
From: "Toma? Grom" <tomaz.grom@siol.net>
Newsgroups: Advantage.Xbase++
Subject: Special Slovenian characters in database
Date: Mon, 4 Feb 2008 14:34:32 +0100
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 89.212.202.125
Message-ID: <47a7131f@solutions.advantagedatabase.com>
X-Trace: 4 Feb 2008 06:29:03 -0700, 89.212.202.125
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.212.202.125
Xref: solutions.advantagedatabase.com Advantage.Xbase++:916
Article PK: 1140764

I'm doing sql select statements on ADS dictionary database.
I'm having problems with one special Slovenian character. If I type it
here, it will be displayed wrong on your screen. It is character under acsii
number 142 for uppercase and 158 for lowercase.
When I use UPPER(fieldname) = 'SOMETHING' in WHERE clause, and there is that
special character included in fieldname, the result will only show the
fields that already had the right case of the character.
So I made a test. Two select statements:

SELECT fieldname from ....

and

SELECT LOWER(fieldname) as fieldname from ...

In both cases I get an uppercase character.
I use OEM character set, but I didn't have any problems because of that
until now.

Does anybody know a workaround?
Is it maybe a bug in ADS?

Best regards,
Toma? Grom


Toma? Grom Posted on 2008-02-06 10:29:35.0Z
From: "Toma? Grom" <tomaz.grom@siol.net>
Newsgroups: Advantage.Xbase++
References: <47a7131f@solutions.advantagedatabase.com> <6c56a922383ea8ca352357574427@devzone.advantagedatabase.com>
Subject: Re: Special Slovenian characters in database
Date: Wed, 6 Feb 2008 11:29:35 +0100
Lines: 57
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: 89.212.202.125
Message-ID: <47a98ac5@solutions.advantagedatabase.com>
X-Trace: 6 Feb 2008 03:24:05 -0700, 89.212.202.125
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.212.202.125
Xref: solutions.advantagedatabase.com Advantage.Xbase++:919
Article PK: 1140767

I have checked the character set on the ADS Server and i was set to English
UK. So I set it to Slovenian and in works like a charm :)
Thank you again Rodd!

Best regards,
Toma? Grom

"Rodd Graham" <rgraham@grahamautomation.com> je napisal v sporo?ilo
news:6c56a922383ea8ca352357574427@devzone.advantagedatabase.com ...

> Hello Toma? Grom,
>
>> I'm doing sql select statements on ADS dictionary database.
>> I'm having problems with one special Slovenian character. If I type
>> it
>> here, it will be displayed wrong on your screen. It is character under
>> acsii
>> number 142 for uppercase and 158 for lowercase.
>
> ASCII is 7 bit only. Code points are 0x00 to 0x7F.
>
>> When I use UPPER(fieldname) = 'SOMETHING' in WHERE clause, and there
>> is that
>> special character included in fieldname, the result will only show the
>> fields that already had the right case of the character.
>> So I made a test. Two select statements:
>> SELECT fieldname from ....
>>
>> and
>>
>> SELECT LOWER(fieldname) as fieldname from ...
>>
>> In both cases I get an uppercase character.
>> I use OEM character set, but I didn't have any problems because of
>> that
>> until now.
>> Does anybody know a workaround?
>> Is it maybe a bug in ADS?
>
> Probably not a bug. More likely an Xbase++ and/or ADS character set
> conversion or mismatch.
>
> Please specify your ADS character set setting, your machine character set,
> and your Xbase++ character settings.
> As you already know, Xbase++ does not do OEM characters with the ADSDBE
> driver, only ANSI.
>
> You can review ADS ANSI character sets via the ANSICHR.EXE utility for
> ADSLocal.
>
> Regards,
>
> Rodd Graham, Consultant
> Graham Automation Systems, LLC
>
>