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.

²»ÄÜÖÐÎÄ×÷Ñ¡ÔñÌõ¼þ WITH SYBASE AND BDE£¿£¡

2 posts in iAnywhere General Discussion (Chinese) Last posting was on 2003-01-22 19:49:10.0Z
Bao Yadong Posted on 2003-01-22 02:30:25.0Z
Reply-To: "Bao Yadong" <baoyd@creasoft.com.sg>
From: "Bao Yadong" <baoyd@creasoft.com.sg>
Subject: ²»ÄÜÖÐÎÄ×÷Ñ¡ÔñÌõ¼þ WITH SYBASE AND BDE£¿£¡
Date: Wed, 22 Jan 2003 10:30:25 +0800
Lines: 39
Organization: Creative Software
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <DvzLOEcwCHA.254@forums.sybase.com>
Newsgroups: ianywhere.public.chinese.general
NNTP-Posting-Host: 203.125.230.50
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.chinese.general:140
Article PK: 276

Hi,
I am using C++ builder 5.0 to developing application. The database is
Sybase Server Anywhere 6.0.
I encount problem when I am using chinese charaters.
I connect Database through ODBC.
I have tested the following statement in SQL Explore or query component in
C++ builder
select * from personal where SexID='ÄÐ' //get all male employee
It will return nothing.
But if I test the same statement in DBISQL which is a tools provided by
Sybase
It will return me all male employee correctly.

Actually I realise something
if we test following statement in SQL Explore in C++ builder
1. select length('ÄÐ')
It will return 1, but actually it should return 2 because 'ÄÐ' is a
chinese charater.
2. select length(SexID) from personal
It will return 2.
I guss that is why "select * from personal where SexID='ÄÐ'" return me
nothing

But if I test "select length('ÄÐ')" and "select length(SexID) from
personal" in
DBISQL. They all return me 2.

I think the only difference between SQL Explore and DBISQL is BDE. DBISQL
directly uses sybase ODBC driver and SQL Explore needs go through BDE.

Anyone has solution for that?


Thanks very much

Bao Yadong
baoyd@creasoft.com.sg


Raymond Kwong Posted on 2003-01-22 19:49:10.0Z
From: "Raymond Kwong" <rkwong@sybase.com>
References: <DvzLOEcwCHA.254@forums.sybase.com>
Subject: Re: ²»ÄÜÖÐÎÄ×÷Ñ¡ÔñÌõ¼þ WITH SYBASE AND BDE£¿£¡
Date: Wed, 22 Jan 2003 14:49:10 -0500
Lines: 50
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <4DRguHlwCHA.285@forums.sybase.com>
Newsgroups: ianywhere.public.chinese.general
NNTP-Posting-Host: 172.31.141.208
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.chinese.general:135
Article PK: 282

We are already answering your thread in ianywhere.public.general where some
more English-speaking colleagues would be able to help you too.

Raymond Kwong
iAnywhere Solutions

"Bao Yadong" <baoyd@creasoft.com.sg> wrote in message
news:DvzLOEcwCHA.254@forums.sybase.com...
> Hi,
> I am using C++ builder 5.0 to developing application. The database is
> Sybase Server Anywhere 6.0.
> I encount problem when I am using chinese charaters.
> I connect Database through ODBC.
> I have tested the following statement in SQL Explore or query component
in
> C++ builder
> select * from personal where SexID='ÄÐ' //get all male employee
> It will return nothing.
> But if I test the same statement in DBISQL which is a tools provided by
> Sybase
> It will return me all male employee correctly.
>
> Actually I realise something
> if we test following statement in SQL Explore in C++ builder
> 1. select length('ÄÐ')
> It will return 1, but actually it should return 2 because 'ÄÐ' is a
> chinese charater.
> 2. select length(SexID) from personal
> It will return 2.
> I guss that is why "select * from personal where SexID='ÄÐ'" return
me
> nothing
>
> But if I test "select length('ÄÐ')" and "select length(SexID) from
> personal" in
> DBISQL. They all return me 2.
>
> I think the only difference between SQL Explore and DBISQL is BDE. DBISQL
> directly uses sybase ODBC driver and SQL Explore needs go through BDE.
>
> Anyone has solution for that?
>
>
> Thanks very much
>
> Bao Yadong
> baoyd@creasoft.com.sg
>
>