Hi, When i pass a Non-ASCII string in where condition filter of an raw SQL statement, the SQLALCHEMY showing below error during an execution of query File "/base/data/home/apps/s~ipaddress/versionnumber/flow/services/requestExport.py", line 119, in getRecordsFromDB instanceList = self.session.raw_table_join_query(metadata, baseQuery, columns, orderBy = args['orderBy'], isDescending = args['isDescending'], limit=5000, includeAttachments=args.get('includeAttachments')) File "/base/data/home/apps/s~ipaddress/versionnumber/orangescape/model/server/sql/SQLSession.py", line 724, in raw_table_join_query rs = self.getConnection().execute(sql) File "/base/data/home/apps/s~ipaddress/versionnumber/sqlalchemy/engine/base.py", line 1294, in execute params) File "/base/data/home/apps/s~ipaddress/versionnumber/sqlalchemy/engine/base.py", line 1471, in _execute_text statement, parameters File "/base/data/home/apps/s~ipaddress/versionnumber/sqlalchemy/engine/base.py", line 1528, in _execute_context context) File "/base/data/home/apps/s~ipaddress/versionnumber/sqlalchemy/engine/default.py", line 325, in do_execute cursor.execute(statement, parameters) File "/base/data/home/runtimes/python27/python27_lib/versions/1/google/storage/speckle/python/api/rdbms.py", line 565, in execute request.statement = _ConvertFormatToQmark(statement, args) File "/base/data/home/runtimes/python27/python27_lib/versions/1/google/net/proto2/python/internal/python_message.py", line 449, in setter self._fields[field] = type_checker.CheckValue(new_value) File "/base/data/home/runtimes/python27/python27_lib/versions/1/google/net/proto2/python/internal/type_checkers.py", line 151, in CheckValue (proposed_value)) *ValueError: "SELECT po.id FROM purchaseorder as po where po.customername = 'Twójstarski'" t has type bytes, but isn't in 7-bit ASCII encoding. Non-ASCII strings must be converted to unicode objects before being added.*
The below is the query i'm using *SELECT po.id FROM purchaseorder as po where po.customername = 'Twójstarski'* I tried passing the value has an unicode string, this time the query getting executed properly but without any result set. Please suggest me the way to deal with this Non-ASCII string. Regards Pravin B -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.