SET NAMES, COLLATE... DIALECT 3 x D5 + IB6

Article View: borland.public.interbase.sql

Article #11124

Back to borland.public.interbase.sql Previous Next

#11124

From: Marcos
Date: Fri, 13 Dec 2002 19:54

19 lines
1422 bytes

Hi!
     I'm needing to run this script using IB6 and D5. What am i doing wrong?

"
SET SQL DIALECT 3
SET NAMES ISO8859_1;
create table endalns (aluno varchar(8) not null COLLATE PT_PT , nome
varchar(50) COLLATE PT_PT, ...
"
 or

"
SET SQL DIALECT 3
create table endalns (aluno varchar(8) not null CHARACTER SET ISO8859_1
COLLATE PT_PT , nome varchar(50) CHARACTER SET ISO8859_1 COLLATE PT_PT, ...
"

Thanks in Advance
Marcos

Technical Details

Message-ID: <3dfa2cd1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,c96891c6cceb3b41,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-13 10:58:55 PST
Reply-To: "Marcos" <marcospaulo@portesistemas.com.br>
From: "Marcos" <marcospaulo@portesistemas.com.br>
Newsgroups: borland.public.interbase.sql
Subject: SET NAMES, COLLATE... DIALECT 3 x D5 + IB6
Date: Fri, 13 Dec 2002 16:54:09 -0300
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 200.102.24.184
Message-ID: <3dfa2cd1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039805649 200.102.24.184 (13 Dec 2002 10:54:09 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail