[Monetdb-developers] ANSI Characters
Hi,
I am trying to insert ansi characters and it doesn't seem to be working in monetdb/sql
insert into reason values(100,'SAVE 25¢ ON ICE CREAM');
reason is a table with Id integer message string
The client thinks the query is not complete and prompts '>more'. What should i configure to get this working
Thanks Bharani
On 30-07-2007 05:35:36 -0700, Bharani wrote:
Hi,
I am trying to insert ansi characters and it doesn't seem to be working in monetdb/sql
insert into reason values(100,'SAVE 25¢ ON ICE CREAM');
reason is a table with Id integer message string
The client thinks the query is not complete and prompts '>more'. What should i configure to get this working
What happens if you try the same with JdbcClient? It might be a locale problem.
Tried that too - I get 'unexpected end of input'
Fabian Groffen wrote:
On 30-07-2007 05:35:36 -0700, Bharani wrote:
Hi,
I am trying to insert ansi characters and it doesn't seem to be working in monetdb/sql
insert into reason values(100,'SAVE 25¢ ON ICE CREAM');
reason is a table with Id integer message string
The client thinks the query is not complete and prompts '>more'. What should i configure to get this working
What happens if you try the same with JdbcClient? It might be a locale problem.
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
On 30-07-2007 05:45:27 -0700, Bharani wrote:
Tried that too - I get 'unexpected end of input'
does this work for you?
Welcome to the MonetDB interactive JDBC terminal! Database: MonetDB v5.1.0, 'demo' Driver: MonetDB Native Driver v1.6 (Steadfast_p6 20070720 based on MCL v1.0) Type \q to quit, \h for a list of available commands auto commit mode: on monetdb-> select 'SAVE 25¢ ON ICE CREAM'; +------------------------+ | single_value | +========================+ | SAVE 25¢ ON ICE CREAM | +------------------------+ 1 row
monetdb->
No :( . I get the same error. Clearly something is wrong with my testing. But i am using windows so anything else should i check for?
Fabian Groffen wrote:
On 30-07-2007 05:45:27 -0700, Bharani wrote:
Tried that too - I get 'unexpected end of input'
does this work for you?
Welcome to the MonetDB interactive JDBC terminal! Database: MonetDB v5.1.0, 'demo' Driver: MonetDB Native Driver v1.6 (Steadfast_p6 20070720 based on MCL v1.0) Type \q to quit, \h for a list of available commands auto commit mode: on monetdb-> select 'SAVE 25¢ ON ICE CREAM'; +------------------------+ | single_value | +========================+ | SAVE 25¢ ON ICE CREAM | +------------------------+ 1 row
monetdb->
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
On 30-07-2007 05:58:55 -0700, Bharani wrote:
No :( . I get the same error. Clearly something is wrong with my testing. But i am using windows so anything else should i check for?
I'm not sure who/what goes wrong, but it must be related to the locale.
First, your and my emails are encoded as UTF-8, the same encoding as MonetDB uses. My environment is UTF-8 as well, so in my case it is perfectly communicated to the server. Java should do the character encoding thing for you, if you don't have an UTF-8 environment. I don't doubt that this works correctly, as this is important for Java itself. Since MapiClient has the same problem, it can be a problem of the server. Can you make a JDBC log so we can see what encoding Java sends over the wire to the server?
Bharani wrote:
Hi,
I am trying to insert ansi characters and it doesn't seem to be working in monetdb/sql
insert into reason values(100,'SAVE 25¢ ON ICE CREAM');
reason is a table with Id integer message string
The client thinks the query is not complete and prompts '>more'. What should i configure to get this working
Thanks Bharani
MonetDB does not support ANSI characters, only UTF-8 encoded characters.
participants (3)
-
Bharani
-
Fabian Groffen
-
Sjoerd Mullender