ODBC-Driver for 11.5er / Problems with Long Varchars

forum.sqlbase (2000-2010)
NewsgroupServer
Robot
Robot
Posts: 115623
Joined: 24 Feb 2017, 12:00
Location: World wide

ODBC-Driver for 11.5er / Problems with Long Varchars

Post by NewsgroupServer » 03 Feb 2009, 14:57

 Posted by:  Marco Westermann 

Hi,

we have installed the new 11.5er release of the Gupta SQLBase Server and
we have a big problem with long varchars.. when fetching a long field
within crystal over the ODBC-Driver I only see hieroglyphs. When using
the OLEDB-Driver, everything works fine. But I cant change everything in
the programm to oledb-access.

Anybody has an Idea?

Thanks Marco

NewsgroupServer
Robot
Robot
Posts: 115623
Joined: 24 Feb 2017, 12:00
Location: World wide

ODBC-Driver for 11.5er / Problems with Long Varchars

Post by NewsgroupServer » 04 Feb 2009, 01:35

 Posted by:  Mike Vandine 

Hi Marco,

How did you get the database converted to 11.5? Did you do an unload/load
from the previous version or did you move the .dbs file into the new 11.5
server and connect to it?

During a load, a long varchar is converted to a new datatype long varbinary
(see the release notes). If you just move the .dbs file and connect to it,
this conversion does not happen.

Hope this helps!

Mike

NewsgroupServer
Robot
Robot
Posts: 115623
Joined: 24 Feb 2017, 12:00
Location: World wide

ODBC-Driver for 11.5er / Problems with Long Varchars

Post by NewsgroupServer » 04 Feb 2009, 16:53

 Posted by:  Marco Westermann 

Hi Mike, thanks for your fast reply. Now I figured out the following:

when copying a dbs file from 9.0.1 and use it in 11.5 the longvars stays
longvars.
But over the odbc the text is different:
in SQLTalk: Hallo there
in Crystal over ODBC: 48616C6C6F207468657265
in Crystal over OLEDB: it stays empty (Crystal interprets it as blob)

when converting the db from 9.0.1 to 11.5 over Unload/load I get the
following:
in SQLTalk: Hallo there
in Crystal over ODBC: it stays empty (crystal interprets it as blob)
in Crystal over OLEDB: it stays empty (crystal interprets it as blob)

next test:
from within sqltalk:
create table test (
t1 long varchar
);
insert into test (t1) values (:1)
\
Hallo there
/

Access over ODBC in Crystal: (unprintable characters: box | box box box)
(this was what I called hieroglyphs)

Access over OLEDB in Crystal: Hallo there (this works!!!!)

Did I mention that we use a german characterset (country=germany) in
sql.ini (don't know if this does matter) Here is the declaration from
country.sql:

[germany]
#whitespace
\9 \A \D \20
#numeric
0 1 2 3 4 5 6 7 8 9
#alpha
;(angepaát f?r Windows-Client an ANSI !)
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z \C4 \D6 \DC
a b c d e f g h i j k l m n o p q r s t u v w x y z \E4 \F6 \FC \DF
#translate
\E4 a
\C4 A
\F6 o
\D6 O
\FC u
\DC U
\DF s
\DF ss
\E4 ae
\C4 Ae
\F6 oe
\D6 Oe
\FC ue
\DC Ue
; ab hier Test
a A
b B
c C
d D
e E
f F
g G
h H
i I
j J
k K
l L
m M
n N
o O
p P
q Q
r R
s S
t T
u U
v V
w W
x X
y Y
z Z
#lower
\C4 \E4
\D6 \F6
\DC \FC
#upper
\E4 \C4
\F6 \D6
\FC \DC
[germany]
;same germany code page, different sort collating sequence
;Umlautkonvertierung f?r Zeichensatz unter Windows !
#whitespace
\9 \A \D \20
#numeric
0 1 2 3 4 5 6 7 8 9
#alpha
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z \C4 \D6 \DC
a b c d e f g h i j k l m n o p q r s t u v w x y z \E4 \F6 \FC \DF
#translate
\E4 \61
\C4 \41
\F6 \6F
\D6 \4F
\DF \73
\FC \75
\DC \55
\DF ss
#lower
\C4 \E4
\D6 \F6
\DC \FC
#upper
\E4 \C4
\F6 \D6
\FC \DC
;\63 ch
;\43 CH
;#prefix

NewsgroupServer
Robot
Robot
Posts: 115623
Joined: 24 Feb 2017, 12:00
Location: World wide

ODBC-Driver for 11.5er / Problems with Long Varchars

Post by NewsgroupServer » 04 Feb 2009, 18:28

 Posted by:  Marco Westermann 

Ok, just figured out, that using the 9.0.1-ODBC-Driver on the database
with the unload/load migration works.

best regards Marco

Return to “forum.sqlbase”

Who is online

Users browsing this forum: [Ccbot] and 0 guests