Hello.
No, I was not able to connect via pymssql. Furthemore I would like to use pyodbc
if it is the preferred way. I just did not know that when I started with
pymssql.
It really is a misconfigured character encoding issue in pyodbc / freetds on my
part. I am just clueless as to what should I set to what to make it all work.
The code:
cnxn =
pyodbc.connect('DRIVER={FreeTDS};SERVER=10.230.128.140;PORT=1433;DATABASE=ZFP_CRM;UID=efractal;PWD=efR@cZFP13;TDS_VERSION=8.0')
cursor = cnxn.cursor()
cursor.execute("select prijmeni from osoba where id_osoba = 462493")
row = cursor.fetchone()
print row
prints:
('Ne?asov', )
The correct value is 'Nečasová'. Ideally I would like to see the following:
(u'Nečasová', )
On a side note, the returned value is one character shorter. I would expected:
('Ne?asov?', )
However, when I connect via tsql, it works correcly:
tsql -S zfp -U efractal
Password:
locale is "cs_CZ.UTF-8"
locale charset is "UTF-8"
using default charset "utf8"
1> select prijmeni from osoba where id_osoba = 462493
2> go
prijmeni
Nečasová
(1 row affected)
1>
I guess I am on my own now. Anyway, thank you for your kind assistance.
Ladislav Lenart
On 8.10.2012 19:06, Michael Bayer wrote:
> if you didnt have this problem with pymssql then please apply the patch I
> sent previously.
>
> However, I'm going to bet the problem remains as it seems something is not
> right with how your database and/or client is configured. I'm not familiar
> with the encoding pattern seen in your information_schema queries. you may
> have to reproduce the issue using plain SELECT statements against
> information_schema and then seek outside help.
>
>
>
> diff -r 17cab4ad55d5 lib/sqlalchemy/dialects/mssql/pymssql.py
> --- a/lib/sqlalchemy/dialects/mssql/pymssql.py Thu Oct 04 18:26:55
> 2012 -0400
> +++ b/lib/sqlalchemy/dialects/mssql/pymssql.py Fri Oct 05 18:46:01
> 2012 -0400
> @@ -80,7 +80,7 @@
> def _get_server_version_info(self, connection):
> vers = connection.scalar("select @@version")
> m = re.match(
> - r"Microsoft SQL Server.*? - (\d+).(\d+).(\d+).(\d+)", vers)
> + r"\s*Microsoft SQL Server.*? - (\d+).(\d+).(\d+).(\d+)", vers)
> if m:
> return tuple(int(x) for x in m.group(1, 2, 3, 4))
> else:
>
> On Oct 8, 2012, at 12:10 PM, Ladislav Lenart wrote:
>
>> Hello.
>>
>> I adjusted the ODBC/FreeTDS condifugration according to your suggestions but
>> still get the "NoSuchTableError: mlm_spol".
>>
>> freetds.conf:
>>
>> [zfp]
>> host = 10.230.128.140
>> port = 1433
>> tds version = 8.0
>> asa database = ZFP_CRM
>> client charset = utf8
>> text size = 50000000
>>
>>
>> odbc.ini:
>>
>> [ODBC Data Sources]
>> zfp = test
>>
>> [zfp]
>> Driver = /usr/lib/libtdsodbc.so
>> Description = test
>> Trace = No
>> Servername = zfp
>>
>>
>> odbcinst.ini (for the sake of completeness):
>>
>> [FreeTDS]
>> Driver = /usr/lib/libtdsodbc.so
>> UsageCount = 2
>>
>>
>> The code:
>>
>> from sqlalchemy.engine import create_engine
>> from sqlalchemy.ext.sqlsoup import SqlSoup
>>
>> if __name__ == '__main__':
>> engine = create_engine("mssql://efractal:efR@cZFP13@zfp", echo='debug')
>> db = SqlSoup(engine)
>> x = db.mlm_spol.fetchone()
>> print x
>>
>>
>> still fails with NoSuchTableError: mlm_spol
>>
>> Its debug output is the same as in my previous email which used different
>> connect style.
>>
>> And the code that uses db.execute('select * from mlm_spol').fetchone() still
>> works...
>>
>> Any other ideas?
>>
>> Ladislav Lenart
>>
>>
>> On 8.10.2012 17:45, Michael Bayer wrote:
>>> your freetds datasource should be configured with CLIENT_CHARSET=utf8 as I
>>> illustrated earlier:
>>>
>>> [ms_2005]
>>> host = 172.16.248.128
>>> port = 1213
>>> tds version = 8.0
>>> client charset = UTF8
>>> text size = 50000000
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
