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.

Language problems with INSERT INTO from .csv file ? dbisql / dbisqlc

2 posts in General Discussion Last posting was on 2009-12-03 13:20:18.0Z
pooh Posted on 2009-12-03 12:51:05.0Z
From: pooh <jingjingmisen@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: Language problems with INSERT INTO from .csv file ? dbisql / dbisqlc
Date: Thu, 3 Dec 2009 04:51:05 -0800 (PST)
Organization: http://groups.google.com
Lines: 21
Message-ID: <8de6eef0-20e7-449f-8c14-fbf323260e43@j14g2000yqm.googlegroups.com>
NNTP-Posting-Host: 81.191.64.7
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1259844665 28305 127.0.0.1 (3 Dec 2009 12:51:05 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 3 Dec 2009 12:51:05 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: j14g2000yqm.googlegroups.com; posting-host=81.191.64.7; posting-account=J23dPAoAAACM4bXh9E0JqhG7J96Y1eWh
User-Agent: G2/1.0
X-HTTP-Via: 1.1 NOPROXY
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!j14g2000yqm.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28729
Article PK: 77971

My language characters translates to ("+") signs after I have imported
it to my database. Using this parameter in the a BAT file. In my
language we use (å, ö, ø, ä, æ)

"c:\Program Files\Sybase\ASA\win32\dbisql.exe" -c UID=dba;PWD=change;
import.sql

But when I´m using this one below is works. The only differance is
dbisql / dbisqlc

"c:\Program Files\Sybase\ASA\win32\dbisqlc.exe" -c
UID=dba;PWD=change123; import.sql

I could use dbisqlc but then this option isn´t working in my
statement:

SET OPTION PERCENT_AS_COMMENT=OFF

any ideas ?

// Regards


pooh Posted on 2009-12-03 13:20:18.0Z
From: pooh <jingjingmisen@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: Re: Language problems with INSERT INTO from .csv file ? dbisql / dbisqlc
Date: Thu, 3 Dec 2009 05:20:18 -0800 (PST)
Organization: http://groups.google.com
Lines: 27
Message-ID: <56b3daad-bf3d-4cbf-b8d5-090d671708b6@c3g2000yqd.googlegroups.com>
References: <8de6eef0-20e7-449f-8c14-fbf323260e43@j14g2000yqm.googlegroups.com>
NNTP-Posting-Host: 81.191.64.7
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1259846418 31357 127.0.0.1 (3 Dec 2009 13:20:18 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 3 Dec 2009 13:20:18 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: c3g2000yqd.googlegroups.com; posting-host=81.191.64.7; posting-account=J23dPAoAAACM4bXh9E0JqhG7J96Y1eWh
User-Agent: G2/1.0
X-HTTP-Via: 1.1 NOPROXY
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!c3g2000yqd.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28730
Article PK: 77972

I solved it using

-codepage ISO8859_1 in my connection parameter

On 3 Dec, 13:51, pooh <jingjingmi...@gmail.com> wrote:
> My language characters translates to ("+") signs after I have imported
> it to my database. Using this parameter in the a BAT file. In my
> language we use (å, ö, ø, ä, æ)
>
> "c:\Program Files\Sybase\ASA\win32\dbisql.exe" -c UID=dba;PWD=change;
> import.sql
>
> But when I´m using this one below is works. The only differance is
> dbisql / dbisqlc
>
> "c:\Program Files\Sybase\ASA\win32\dbisqlc.exe" -c
> UID=dba;PWD=change123; import.sql
>
> I could use dbisqlc but then this option isn´t working in my
> statement:
>
> SET OPTION PERCENT_AS_COMMENT=OFF
>
> any ideas ?
>
> // Regards