[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 -- View this message in context: http://www.nabble.com/ANSI-Characters-tf4169853.html#a11862871 Sent from the monetdb-developers mailing list archive at Nabble.com.
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
-- View this message in context: http://www.nabble.com/ANSI-Characters-tf4169853.html#a11863003 Sent from the monetdb-developers mailing list archive at Nabble.com.
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
-- View this message in context: http://www.nabble.com/ANSI-Characters-tf4169853.html#a11863190 Sent from the monetdb-developers mailing list archive at Nabble.com.
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. -- Sjoerd Mullender
participants (3)
-
Bharani -
Fabian Groffen -
Sjoerd Mullender