World: r3wp

but first load correct charset, for example:
ucs2/load-rules "ISO-8859-1"

or let the sql server know, what encoding you are using (that it's 
not UTF8)

this should the best way (I just don't remember the correct command)

in MySQL I for example use: "SET character_set_client = cp1250"

http://www.postgresql.org/docs/7.4/static/multibyte.html

if you set the encoding on the server side, you don't need to convert 
your strings in Rebol but let the server to do that job

It seems for me too the best aproach too.

One another case where to use encoding funcions could be PDF maker 
- I had trouble to get pdf output into special characters of my language.

here are charset ids you can load into my scripts: print read http://box.lebeda.ws/~hmm/rebol/projects/ucs2/latest/charmaps.rb

janeks: unfortunately the pdf format does not support unicode, so 
that's not trivial to do... i will do it, eventually.

I've been using  pgsql-protocol (r090)  to store HTML reports into 
the DB. 


It can write a large compressed string into a text column ok. Trying 
to read the data back causes the program to hang. The length of the 
stored string returns 182514 chars. (In psql: SELECT length(html) 
FROM reports....)

Test Code;

sql: {SELECT html FROM reports.html_reports WHERE ticket = '2007-756-fcw'}
insert db-port sql
html: first db-port
.... rest of test program never gets executed.

Does anyone know if this a known behaviour? Thanks

For information, if I select any other column, the program runs as 
expected. The data is these columns is a lot smaller in length.

They might be several reasons why this don't work. Try using LIMIT 
as a cheap workaround : http://pgsqld.active-venture.com/queries-limit.html

If this don't work, tell me what Postgres server version are you 
using, I'll try to reproduce the error.

Ok thanks. I'll double check the exact number tommorrow, but it's 
the 8.1 series. LIMIT would be a good idea, but the query returns 
only one row. It's the amount of data in the one column that is the 
problem. (Whole HTML reports in one chunk). I was thinking that I 
should split up the report into a set of smaller chunks as it gets 
generated  anyway.


I'll give you some more info tommorrow. I appreciate you are busy 
with Cheyenne, so thanks for your time.

No problem, I'm usually much more productive under pressure ;-)

What's the current status of the postgresql driver   ?   Should one 
use mysql instead?

Or SQLite?

Not SQLite ... as I need something that is not memory based.

Got databases over 2Gb in size

SQLite is not memory based imo. It was RebDB. SQLite is the coolest 
thing on earth for the purpose it is supposed to serve :-) I mean 
- small, embeddable SQL engine. MySQLLib is not good solution imo, 
as it does not use SQL syntax and is not even free for embedded stuff.

There is one defficiency with SQLite - it is one user solution. Well, 
you can lock iirc, on file level (yes, even records), but SQL requests 
are not serialised, so you have to think twice, when more than one 
client would connect to database.

As for PostGress, IIRC the driver was in better state than the one 
of mySQL? It even used continual parsing. Doc said later on even 
mySQL driver will be rewritten that way, and maybe it already is, 
dunno.

Oh ... my bad.

I will have multiple clients accessing the database .. webserver, 
 update utiliities and main engine

Graham, Dock's Mysql driver run on eavy tasks without a hitch 8)

I'm just not sure that Mysql's license will eventually catch doc's 
work as well.

So, my preference is for postgresql if I can.

i have experienced a sort of problem : i needed a native driver for 
sql server in rebol because odbc wasnt suitable.  Does this exist 
or its not possible ?

I think sql server is only odbc

yes, what a pity.  i wonder how you can write a driver for a database 
.... i d like to try to do it just for fun

I've always wondered the same thing.  Same with creating ports of 
other language functions or custome controls (widgets) etc.

do you mean MS sql server?

Galt Barber wrote an SQL -Proxy for MS-SQL7 a few years ago. Modifying 
his script I was able to snoop the connections to the Caché DB too.

There is a native non-odbc client library for ms sql that is fast. 
There is also a TCP line protocol to access it.

can u tell me where is it ?

http://www.microsoft.com/downloads/details.aspx?FamilyId=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&DisplayLang=en#SNAC

That is the native client. Tell us if you have any luck with it.

By the way, ODBC and OLEDB are the native access methods of MS SQL 
Server - they are not an add-on layer. The tcp line protocol is the 
same protocol that the client libraries use. I think there is a few 
open source libraries that support the tcp connections (such as FreeTDS), 
though they may not be very current. You might be able to look at 
their code and docs to figure out the protocol.

my friend uses MSSQL with its command line tool ....

Even the command line tools connect through oledb or odbc.

ok i have the dll and i wonder what to do now .... if anyone can 
give me informations ....

If you have Command or the SDK write a wrapper using C Callbacks 
(google for that + rebol) and the /Library component

.

I am trying PGSQL with Doc's protocol and getting 'open pgsql'  error 
"** Script Error: find expected series argument of type: series object 
port bitse
t

** Near: fast-query: either args: find port/target"     This is Postgres 
9.0 recently downloaded.   Anyone having success with it?

Have you provided a database name in the connection URL?

Thanks Kaj.... looks like the NIC MAC is the only reliable one that 
meets the criteria.

ouch wrong group

Doc I tried db: open pgsql://postgres:[xxxxxxxx-:-127-:-0-:-0-:-1]:5432/postgres/ 
 where postgres is listed as a db on  pgAdmin III

Ouch it's the trailing slash

Btw, you only need to provide the port-id if it's not the default 
one (5432).

Let us know if it works ok with PostgreSQL v9.0. I haven't tested 
it since v7.3.

Will do.  Thanks for your work on this enabler ... it's a long list 
of your work that i leverage.  [looking for the donate button ....]