[REBOL] Re: ODBC
From: gchiu:compkarori at: 11-Dec-2000 7:56
On Sun, 10 Dec 2000 09:19:02 -0900
Ric Shepard <[ric_shepard--fishgame--state--ak--us]> wrote:
> Glad to see you've found the problem. I've had no
> success
> trying to reproduce it, here. One thing, though - I
> found
> that my recommendation (double-quoting the strings) was
> bad
> advice (unless you want quoted text in your database).
create-table1: "insert db-port [ {create table reboltest (
fname char(20) not null primary key, birthday timestamp
default 'NOW' ) } ]"
create-table4: "insert db-port [ {create table reboltest (
fname varchar(20) not null primary key, birthday timestamp
default 'NOW' ) } ]"
I isolated it to the char(20) field. If I change fname to
varchar(20), then the character scrambling goes away.
--
Graham Chiu