handling unicode data

F

Filipe

Dennis said:
The setting most likely has to be made on the machine running the
server -- and M$ SQL Server doesn't exist on Linux either <G>

If the conversion was being done by some client library on Windows,
then again, since that library probably doesn't exist on Linux, the
conversion probably is not done.

yes, it's something done on the client side. And I think DB-Library
does exist on Linux because Pymssql depends on it and Pymssql is
cross-platform:

"pymssql 0.7.4 has been tested on FreeBSD 6.0, NetBSD 2.1, 3.0, Linux
with kernel 2.6, and Windows XP. It should also run on other platforms."
 
D

Dennis Lee Bieber

yes, it's something done on the client side. And I think DB-Library
does exist on Linux because Pymssql depends on it and Pymssql is
cross-platform:
If I interpret a short Google search, DB-Library might date back to
the original Sybase core from which M$ SQL Server was spawned. M$'s site
recommends /not/ using DB-Library but to use ODBC/OLEDB methods instead
-- something about ODBC being extensible. Could be confusing if both
Sybase and M$ SQL Server were on the same machine...

http://www.cs.sfu.ca/CourseCentral/Software/Sybase/DB-LIBRARY/DB-LIBRARY.html

Technical details reference Sybase, but the wordy stuff is "SQL
Server" and "Transact-SQL".
--
Wulfraed Dennis Lee Bieber KD6MOG
(e-mail address removed) (e-mail address removed)
HTTP://wlfraed.home.netcom.com/
(Bestiaria Support Staff: (e-mail address removed))
HTTP://www.bestiaria.com/
 
F

Filipe

Dennis said:
If I interpret a short Google search, DB-Library might date back to
the original Sybase core from which M$ SQL Server was spawned. M$'s site
recommends /not/ using DB-Library but to use ODBC/OLEDB methods instead
-- something about ODBC being extensible. Could be confusing if both
Sybase and M$ SQL Server were on the same machine...

http://www.cs.sfu.ca/CourseCentral/Software/Sybase/DB-LIBRARY/DB-LIBRARY.html

Technical details reference Sybase, but the wordy stuff is "SQL
Server" and "Transact-SQL".

The only reason I still think Pymssql (and therefore, DB-Library) might
be the best option is that, it is the only one I know that is both
cross-platform and free - as in beer and as in freedom. (check, in this
thread, a previous message by Tim Golden)

I searched a bit if there are any OLEDB based python libs and found
this one:
http://pyoledb.datadmin.com/

I'm still not sure if it's cross-platform or not, but It does have a
commercial license, so it's not my first choice for now.
 
D

Dennis Lee Bieber

The only reason I still think Pymssql (and therefore, DB-Library) might
be the best option is that, it is the only one I know that is both
cross-platform and free - as in beer and as in freedom. (check, in this
thread, a previous message by Tim Golden)
Don't know if there are any generic ODBC modules that could be used
across the platforms. mxODBC might be the closest, but may need helper
modules... and does have a commercial limitation...

--
Wulfraed Dennis Lee Bieber KD6MOG
(e-mail address removed) (e-mail address removed)
HTTP://wlfraed.home.netcom.com/
(Bestiaria Support Staff: (e-mail address removed))
HTTP://www.bestiaria.com/
 
F

Frank Millman

Filipe said:
The only reason I still think Pymssql (and therefore, DB-Library) might
be the best option is that, it is the only one I know that is both
cross-platform and free - as in beer and as in freedom. (check, in this
thread, a previous message by Tim Golden)

I have bookmarked this post dated October 2004, intending to look into
it one day. I have not done so yet (where does all the time go?). The
subject is "Connecting to SQL Server from Unix".

http://tinyurl.com/zc7so

Try out the suggestions and let us know what happened. I for one will
be very interested.

Frank Millman
 
F

Filipe

Frank said:
Filipe wrote:
Try out the suggestions and let us know what happened. I for one will
be very interested.

The last version of ODBTPAPI is 0.1-alpha, last updated 2004-09-25.
Which is a bit scary...
I might try it just the same though.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,901
Latest member
Noble71S45

Latest Threads

Top