On Wed, Mar 28, 2012 at 1:47 AM, Nuno Tavares wrote:
> Halász, not sure if I understood correcly, but you "mysql" console/client
> may have different charsets. This means you should set it accordingly. Check
Good catch, I had not considered that.
> mysql> set names utf8;
> Query OK, 0 rows affe
Halász, not sure if I understood correcly, but you "mysql"
console/client may have different charsets. This means you should set it
accordingly. Check this out:
mysql> show global variables like '%character_set%';
+--++
| Variable_name
2012/03/27 11:20 -0700, Todd Lyons
This seems backwards from what I expected:
mysql> select convert(0xE29C94 using latin1), convert(0xE29C94 using utf8) \G
*** 1. row ***
convert(0xE29C94 using latin1): âÂÂ
convert(0xE29C94 using utf8)
2012/03/27 12:33 +0200, Johan De Meersman
MySQL does have a proper CSV engine; and it's mystifying why it isnt'
accessible in any other way. I say "engine", and you can take that literally:
just like you have MyISAM and InnoDB engines, CSV is also an engine that is
applicable to tables
2012/3/27 Halász Sándor :
> 2012/03/27 00:22 +0200, Walter Tross
> it looks like it's as simple as this:
> insert into mytable (mycolumn) values (0xE29C94), (0xE29C98)
> In some contexts it might be necessary to force the character set like this,
> though:
> convert(0xE29C94 using utf8)
2012/03/27 00:22 +0200, Walter Tross
it looks like it's as simple as this:
insert into mytable (mycolumn) values (0xE29C94), (0xE29C98)
In some contexts it might be necessary to force the character set like this,
though:
convert(0xE29C94 using utf8)
Yes! and with this I can use
- Original Message -
> From: "Halász Sándor"
>
> input for Word (yes, I have to work MySQL CSV-ish output into real
> CSV, ensuring that there are no escapes in it, nor 'NULL' either).
And this is why it's beneficial to specify your goal along with your question
:-)
MySQL does have a
;>>> 2012/03/25 23:26 +0200, Walter Tross
I guess what you mean is Unicode characters U+2714 'HEAVY CHECK MARK' and
U+2718 'HEAVY BALLOT X'
(http://www.fileformat.info/info/unicode/char/2714/index.htm and
http://www.fileformat.info/info/unicode/char/2718/index.htm).
Unicode has several enco
I guess what you mean is Unicode characters U+2714 'HEAVY CHECK MARK' and
U+2718 'HEAVY BALLOT X'
(http://www.fileformat.info/info/unicode/char/2714/index.htm and
http://www.fileformat.info/info/unicode/char/2718/index.htm).
Unicode has several encodings, of which the most used are UTF-8 and UTF
s.mysql.com
>Sent: Friday, March 23, 2012 5:14 PM
>Subject: big character constant
>
>How does one enter characters U02714 and U02718 in a query? or insert them
>into a record?
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:Â Â http://lists.mysql.com/mysql
>
>
>
>
10 matches
Mail list logo
