Re: How to change character sets in InnoDB as fast as possible

2015-03-23 Thread Rik
from latin1 > character set to utf8. As true conversion will take ages, I had the idea of > just changing the character sets (and preferably collation, too) of the > tables without actually converting the data. Conversion could be done > manually later. From my side it is ok that the dat

How to change character sets in InnoDB as fast as possible

2015-03-23 Thread Thomas Baumann
Hi there, I am looking for a way to convert about 40GB of InnoDB tables from latin1 character set to utf8. As true conversion will take ages, I had the idea of just changing the character sets (and preferably collation, too) of the tables without actually converting the data. Conversion could

Re: Need Help Converting Character Sets

2012-10-01 Thread hsv
2012/09/30 11:07 -0700, Mark Phillips The data for this table comes from a web page (charet utf8). I copy/paste word files into gedit (on linux) and then copy/paste from gedit to a text boxes on the web page input form. I had thought I was stripping out all the funky characters by usin

RE: Need Help Converting Character Sets

2012-10-01 Thread Rick James
says/quotes-in-html.html That is, $#...; is not a character set issue in MySQL. Most CHARACTER SETs (latin1, utf8, etc) will handle them the same. And they will continue to render on an HTML page as the 'funky characters'. That's HTML doing the deed in the browser. The ALTERs

Re: Need Help Converting Character Sets

2012-09-30 Thread Mark Phillips
COLUMN BINARY (or BLOB); -- to forget any charset > knowledge > ALTER TABLE ... MODIFY COLUMN CHARACTER SET ...; -- coming from BINARY, > this does not check the encoding. > (sorry, don't have the link handy) > > > -Original Message- > > From: h...@tb

RE: Need Help Converting Character Sets

2012-09-28 Thread Rick James
the encoding. (sorry, don't have the link handy) > -Original Message- > From: h...@tbbs.net [mailto:h...@tbbs.net] > Sent: Thursday, September 27, 2012 2:24 PM > To: Mark Phillips > Cc: Mysql List > Subject: Re: Need Help Converting Character Sets > > >>&

Re: Need Help Converting Character Sets

2012-09-27 Thread Derek Downey
essage- >> From: Mark Phillips [mailto:m...@phillipsmarketing.biz] >> Sent: Monday, September 24, 2012 4:28 PM >> To: Mysql List >> Subject: Need Help Converting Character Sets >> >> I have a table, Articles, of news articles (in English) with three text &

Re: Need Help Converting Character Sets

2012-09-27 Thread hsv
ped into the observatory?s control room..." Is there a better way to accomplish my first goal, without reading each article and manually making the changes? <<<<<<<< I do not remember where on the MySQL website this is, but there was an article about converting from

RE: Need Help Converting Character Sets

2012-09-24 Thread Rick James
eclared for the column they go in. (Presumably, all the text columns will be declared utf8 or utf8mb4.) > -Original Message- > From: Mark Phillips [mailto:m...@phillipsmarketing.biz] > Sent: Monday, September 24, 2012 4:28 PM > To: Mysql List > Subject: Need Help Convertin

Need Help Converting Character Sets

2012-09-24 Thread Mark Phillips
I have a table, Articles, of news articles (in English) with three text columns for the intro, body, and caption. The data came from a web page, and the content was cut and pasted from other sources. I am finding that there are some non utf-8 characters in these three text columns. I would like to

RE: Character sets

2007-03-19 Thread Adam Graham
As habit I only use UTF in anything I do... and it has paid off many times over. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Character sets

2007-03-19 Thread Ales Zoulek
les Zoulek On 3/19/07, Olaf Stein <[EMAIL PROTECTED]> wrote: Hi All, What character sets would you recommend for a server in the US and all data stays within the English language. Currently everything is set to latin1 with latin1_swedich_ci collation which seems to be the closets one to what

Character sets

2007-03-19 Thread Olaf Stein
Hi All, What character sets would you recommend for a server in the US and all data stays within the English language. Currently everything is set to latin1 with latin1_swedich_ci collation which seems to be the closets one to what I need from what I have read, I was just wondering if there is a

Re: help with character sets and collation

2006-01-28 Thread Chris
_de sjis... Am I correct to assume changes to character sets must be done via command line? cw "Gleb Paharenko" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello. > > Chris, the collation is subordinated to the character set. You should > work w

Re: help with character sets and collation

2006-01-28 Thread Gleb Paharenko
Hello. Chris, the collation is subordinated to the character set. You should work with the character sets, and only after with collations. The data which you store in your table is silently converted to ascii character set. Are you sure that the characters which you want to store are present in

Re: help with character sets and collation

2006-01-27 Thread Chris
>ascii >> 0=>character_set_results >> 1=>latin1 >> 0=>character_set_server >> 1=>latin1 >> 0=>character_set_system >> 1=>utf8 >> 0=>character_sets_dir >> 1=>C:\Program Files\MySQL\MySQL Server 5.0\share\charsets\ >

Re: help with character sets and collation

2006-01-27 Thread Gleb Paharenko
\MySQL Server 5.0\share\charsets\ > > >> show variables like '%collation%'; > > 0=>collation_connection > 1=>latin1_swedish_ci > 0=>collation_database > 1=>ascii_general_ci > 0=>collation_server > 1=>latin1_swedish_ci > >

Re: help with character sets and collation

2006-01-26 Thread Chris
=>latin1_swedish_ci > > Include the CREATE statement for your table as well. CREATE TABLE my_table (location_id varchar(20) NOT NULL default '',name varchar(50) NOT NULL default '',PRIMARY KEY (location_id)) TYPE=MyISAM > > > Chris wrote: >> I think I

Re: help with character sets and collation

2006-01-26 Thread Gleb Paharenko
ve a problem with mysql related character sets and collation. > With language English (en-utf-8), MySQL charset UTF-8 Unicode and a MySQL > connection collation: ascii_general_ci. I can execute a sql statement in > phpmyadmin, like "INSERT INTO mytable (id, name) VALUES ('5'

help with character sets and collation

2006-01-25 Thread Chris
I think I have a problem with mysql related character sets and collation. With language English (en-utf-8), MySQL charset UTF-8 Unicode and a MySQL connection collation: ascii_general_ci. I can execute a sql statement in phpmyadmin, like "INSERT INTO mytable (id, name) VALUES ('5

Re: character sets.....(missing info)

2005-11-20 Thread BÁRTHÁZI András
Hi all, there is no conversion done, and mysql will stil be happy to export utf8 (if asked to do so with a set names). So what is the role of the character set and collation at the database level?From what I understand the collation is used when you want to order results for example, case sen

[OT]Re: character sets.....(missing info)

2005-11-14 Thread mel list_php
To allow multiple character sets to be sent from the client, the "UTF-8" encoding should be used, either by configuring "utf8" as the default server character set, or by configuring the JDBC driver to use "UTF-8" through the characterEncoding property. (from h

Re: character sets.....(missing info)

2005-11-09 Thread BÁRTHÁZI András
Hi Melanie, Thanks for the explanation, I will try the SET NAMES to export my XML file in utf8 (I actually want it to be in utf8) I'm sorry if this is a basic question, but as I said before I'm kind of lost with the encodings I asked almost the same here about a week ago, so I don't think

Re: character sets.....(missing info)

2005-11-09 Thread mel list_php
'm doing thanks for your help, melanie If you write an hungarian article about your test, maybe you will plan an english translation?or is hungarian hard to learn? :-) From: BÁRTHÁZI András <[EMAIL PROTECTED]> To: mel list_php <[EMAIL PROTECTED]> CC: mysql@lists.

Re: character sets.....(missing info)

2005-11-08 Thread BÁRTHÁZI András
utf8" SQL query before querying the data for the *XML* file, and you will get the data in UTF-8. Or just put a header into the XML file that says your data in Latin1 (I think it's not so easy in Java). Anyway, I don't know, how Java handles the character sets related to MySQL at

character sets.....(missing info)

2005-11-08 Thread mel list_php
character_set_client is by default latin1, does that mean that the java application is sending latin1?or is it changed at runtime? kind of lost again. From: "mel list_php" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: character sets. Date: Tue, 08 Nov 2005 17:30:28 + H

character sets.....

2005-11-08 Thread mel list_php
Hi guys, I don't really understand the character set in mysql from the doc. Tu summarize my problem: users upload xml files (UTF-8). part of the data is then inserted into MySQL (CHARSET=latin1) at that point, when I browse via phpmyadmin (which is isolatin1) or export to an html page no proble

dumping a single table that contains fields in multiple character sets

2005-11-02 Thread Michael R. Gile
up a table that contains multiple character sets, since one of the fields will invariably encounter a conversion. Is there an undocumented option that functions as "--binary-charset" ? or are we just left with no way to backup and restore a table with mysqldump anymore? I suppos

Re: MySQL 5.0 & character sets

2005-10-28 Thread Jeffrey Goldberg
On Oct 28, 2005, at 1:06 AM, BÁRTHÁZI András wrote: I'm new on this list, so a very short intro about me: I'm Andras Barthazi, a Hungarian web developer. I like MySQL very much, I'm using it since 3.x versions, so I think I know it very well. But... I'm new to everything, but I can tell you

Re: MySQL 5.0 & character sets

2005-10-28 Thread BÁRTHÁZI András
Hi, Is it a so hard, or a so easy question, that nobody answers it? :) Or just should wait some more hours, and don't hurry so much? ;) Bye, Andras So, I started learning, how MySQL 5.0 handles character sets. It is, what I think about it: character_set_client | latin1 Th

MySQL 5.0 & character sets

2005-10-27 Thread BÁRTHÁZI András
Hi, I'm new on this list, so a very short intro about me: I'm Andras Barthazi, a Hungarian web developer. I like MySQL very much, I'm using it since 3.x versions, so I think I know it very well. But... So, I started learning, how MySQL 5.0 handles character sets. It is, what

Re: Implication and usage of character sets for i18n data (?)

2005-08-08 Thread Gleb Paharenko
Hello. I can't make guessing about Hebrew code page, but MySQL support of character sets was very helpful with my Russian cp1251 encoding. Because windows console supports input on my system only in cp866, while other applications - cp1251. So in mysql command line client I was ab

Implication and usage of character sets for i18n data (?)

2005-08-06 Thread Maxim Vexler
Hello to each and every one of you. I'm wondering about the practical effect of character sets in mysql 4.0 & 4.1 as follows. What is it good for? Assuming I'm storing text data uin windows-hebrew (1255) codepage, to be used by my php application. I can have my database & t

Re: Character Sets in 3.23.58

2005-06-24 Thread Gleb Paharenko
g5) and Vietnamese (Unicode-8 should > work)how do I get it to store alternative character sets? The > docs online only relate to ver 4so the "character set" attribute > doesn't work. > > Any help would be appreciatedI'm new to this multip

Character Sets in 3.23.58

2005-06-23 Thread Andrew Mull
Hello, We are running mySQL 3.23.58 on a RedHat server. We have a database that needs to store Chinese (big5) and Vietnamese (Unicode-8 should work)how do I get it to store alternative character sets? The docs online only relate to ver 4so the "character set" attribute do

Re: Problems with character sets and Unicode in MySQL

2005-04-28 Thread Gleb Paharenko
Hello. >But I've been told that the support for Unicode is not yet good in MySQL. Is >it possible to find whether this is true? I don't think so, as most bugs related to utf8 are reported about the fifth version while utf8 support in fourth seems very stable. Raul Mauri <[EMAIL PRO

Problems with character sets and Unicode in MySQL

2005-04-27 Thread Raul Mauri
I use the MyQSL Query Browser for a library database. I have come across a problem in MySQL: Using extended characters, as š, is not a problem, as long as they are present in the standard 256 characters of a font. Things become more difficult when I need other East Europe characters. Could anyon

Re: setting character sets "permanently"

2005-04-24 Thread Fagyal Csongor
Paul, DBI doesn't read the config file, DBD::mysql does. Erm, yep, I meant that, too :-) It's not expensive at all. Why do you think it's expensive? As the file must be read and parsed at each ->connect(...) invocation. It would be nicer if DBD could read the config file during the "use phase" (f

Re: setting character sets "permanently"

2005-04-24 Thread Paul DuBois
At 0:49 +0200 4/25/05, Fagyal Csongor wrote: Harald, Perhaps the following excerpt from "perldoc DBD::mysql" is relevant for you: mysql_read_default_file mysql_read_default_group These options can be used to read a config file like /etc/my.cnf or ~/.my.cnf. By default MySQL's C client

Re: setting character sets "permanently"

2005-04-24 Thread Fagyal Csongor
Harald, Perhaps the following excerpt from "perldoc DBD::mysql" is relevant for you: mysql_read_default_file mysql_read_default_group These options can be used to read a config file like /etc/my.cnf or ~/.my.cnf. By default MySQL's C client library doesn't use any config files unl

Re: setting character sets "permanently"

2005-04-24 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Fagyal Csongor <[EMAIL PROTECTED]> writes: mysql> show variables like 'character%'; >> +--+ >> -+ >> | Variable_name| Value >> | >> +--+--

Re: setting character sets "permanently"

2005-04-24 Thread Fagyal Csongor
Hmmm, strange... From the mysql client I see: mysql> show variables like "%char%"; +--+-+ | Variable_name| Value | +

Re: setting character sets "permanently"

2005-04-24 Thread Fagyal Csongor
Mathias, 2 other things : 1. what is your character set when you install the mysql server ? I used the binaries from mysql.com. I think that has latin1/swedish as a default. But anyways, I really don't like the idea to recompile MySQL just to get my character sets work all right. 2.

Re: setting character sets "permanently"

2005-04-24 Thread Fagyal Csongor
Mathias, And you can add all those variables to the ini file : character_set_client=latin2 character_set_connection=latin2 character_set_database=latin2 character_set_results=latin2 character_set_server=latin2 No, I can not. MySQL won't start. More precisely, "character_set_results" is not recog

RE: setting character sets "permanently"

2005-04-24 Thread mathias fatene
- From: mathias fatene [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 22:59 To: 'mathias fatene'; 'Fagyal Csongor' Cc: mysql@lists.mysql.com Subject: RE: setting character sets "permanently" And you can add all those variables to the ini file : character_se

Re: setting character sets "permanently"

2005-04-24 Thread Fagyal Csongor
Mathias, [...] I changed my.ini (.my.cnf) like this : [mysqld] # The TCP/IP Port the MySQL Server will listen on port=3306 log-bin = "C:/Program Files/MySQL/MySQL Server 4.1/Data/binlog" #Path to installation directory. All paths are usually resolved relative to this. basedir="C:/Program Files/MySQ

RE: setting character sets "permanently"

2005-04-24 Thread mathias fatene
:47 To: 'Fagyal Csongor' Cc: mysql@lists.mysql.com Subject: RE: setting character sets "permanently" Hi, Look at this : mysql> show variables like 'character%'; +--+ -+ |

RE: setting character sets "permanently"

2005-04-24 Thread mathias fatene
_dir | C:\Program Files\MySQL\MySQL Server 4.1\share\charsets/ | +--+ -+ That's all. Mathias -Original Message- From: Fagyal Csongor [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 22:33 To: mysql@lists.mysql.com Subject: s

setting character sets "permanently"

2005-04-24 Thread Fagyal Csongor
HI, I am using MySQL 4.1.11 on FC3, and I have trouble reading back latin2 characters. No wonder, as character_set_client, character_set_connection and character_set_results are all set to latin1. The problem is that I cannot set them to latin2 _permanently_, I mean every time I connect to the

RE: Character Sets, 4.0 and 4.1

2005-02-04 Thread Kevin Cowley
In addition you need to ensure that all the character sets on the tables default to utf8 (show create table) and that all 'text' type columns (char,varchar, text, etc) have a default type of utf8. On a non-utf8 database where the table is utf8, the default character set on the table and al

Character Sets, 4.0 and 4.1

2005-02-04 Thread Bruce Dembecki
So today for the second time in six weeks we are faced with rolling back to mysql 4.0 because of dramas with character sets. I don't know about anyone else but this supposedly wonderful feature has been nothing but a nightmare for us. So our Application servers use Unicode for our non US En

Re: Character sets and character_set_results

2004-11-16 Thread Martel Valgoerad
>> The problem is, when I get the data from the database via a >> webpage (php) everything works as expected. The problem is when I >> try to get the results from the mysql client (ie. SELECT body FROM >> thread WHERE tid=30) the national accented characters are shown as >> "?". I have browsed thr

Re: Character sets and character_set_results

2004-11-16 Thread Martel Valgoerad
> The problem is, when I get the data from the database via a > webpage (php) everything works as expected. The problem is when I > try to get the results from the mysql client (ie. SELECT body FROM > thread WHERE tid=30) the national accented characters are shown as > "?". I have browsed through

Character sets and character_set_results

2004-11-16 Thread Martel Valgoerad
Hi. I have a problem with the dump and character set - it would be great if someone could help. I have created a database and my tables a long time ago when the database was a the 4.0 version. Yet some time ago, my server admin has upgraded the server to version 4.1.2. I haven't noticed that

Character sets

2004-10-29 Thread Dimitris
I installed mySQL v4.1.7 on windows xp I changed my.ini file two times with different character set. First :default-character-set=utf8 and in my application : codepage=utf8 Second : default-character-set=greek and in my application : codepage=greek (I live in Greece) Running my application I see

confused about character sets in mysql 4.1.3b

2004-07-16 Thread Veysel Harun Sahin
Hello list, I have already installed mysql 4.1.3 beta to my windows xp. I set default-caharacter-set to latin5 and default-collation to latin5_turkish_ci in my.ini configuration file. Because I want latin5 my default character set. Then I restarted mysql service and looked up character set and col

character sets on client or server?

2004-06-28 Thread Marten Lehmann
Hello, do I need the character sets on the client side or just on the server? Client and server are different servers, so I want to reduce the client-package to a minimum: /usr/bin/mysql /usr/bin/mysqldump /usr/bin/mysqlshow /usr/lib/mysql/libmysqlclient* I don't need man-pages et ceter

pashto/dari/arabic character sets question

2004-06-26 Thread Bill French
hello, i'm building a php/mysql based system for reporters on the ground in afghanistan to file stories -- in english, pashto, and dari. will i have to do anything special when compiling mysql so that it supports the right character sets? are arabic character sets supported by default i

Re: Documentation on character sets for version 4.0.17

2004-05-05 Thread Nils Valentin
Hi David, (B (BThank you for the detailed description. That certainly makes things easier to (Bargue now ;-). (B (BO.K Where to start ? (B (BFirst, as you know in version 4.0 you can basically set the character sets (Bonly for server and client side (not for DB, table, columns

Re: Documentation on character sets for version 4.0.17

2004-05-04 Thread David Jourard
Nils, At 05:30 PM 5/4/04 +0100, you wrote: Basically the best guess would be the documentation that comes with your download. Note that online documents at www.mysql.com are always a mixture of several documentation versions really. Thats the problem. Yesterday, I downloaded 4.0.1x yet the docu

Re: Documentation on character sets for version 4.0.17

2004-05-04 Thread Nils Valentin
Hi David, (B (BYou may find my UC-2004 presentation useful as well as some UC-2003 (Bpresentations from Mr. Gulutzan and Mr. Barkov: (B (Bwww.be-known-online.com/mysql (Bmysql.planetmirror.com/Downloads/Presentations/MySQL-User-Conference-2003/National-Character-Sets-and-Unicode.pdf (B

Re: Documentation on character sets for version 4.0.17

2004-05-04 Thread David Jourard
Victoria , Thank-you. At 01:35 PM 5/4/04 +0300, Victoria Reznichenko wrote: David Jourard <[EMAIL PROTECTED]> wrote: > > I got the 4.0.17 documentation but when it discusses character sets it > discusses this topic wrt 4.1 > > Where can I find documentation specifica

Re: Documentation on character sets for version 4.0.17

2004-05-04 Thread Victoria Reznichenko
David Jourard <[EMAIL PROTECTED]> wrote: > > I got the 4.0.17 documentation but when it discusses character sets it > discusses this topic wrt 4.1 > > Where can I find documentation specifically in regards to the production > version on how to work with, store, and sea

Documentation on character sets for version 4.0.17

2004-05-03 Thread David Jourard
Hi, I got the 4.0.17 documentation but when it discusses character sets it discusses this topic wrt 4.1 Where can I find documentation specifically in regards to the production version on how to work with, store, and search asian character sets specifically Japanese. Thank-you David Jrt; x

Re: Basic problem with character sets

2004-02-11 Thread vpendleton
lt;<<<<<<< On 2/11/04, 11:20:30 AM, Julien Martin <[EMAIL PROTECTED]> wrote regarding Basic problem with character sets: > Hello, > I am trying to display the following letter "ñ" (n with ~) on a web page. > Basically I would like for the corre

Basic problem with character sets

2004-02-11 Thread Julien Martin
Hello, I am trying to display the following letter "ñ" (n with ~) on a web page. Basically I would like for the correct letter to appear in the web page as well as on the mysql console as well as in the html source. How do I do that? Thanks in advance, Julien. -- MySQL General Mailing List For l

re: Character sets

2004-01-30 Thread Jeremy March
but can I set multiple "default character set" options to multiple character sets (EUC-JP, EUC-KR, and ISO-8859-1) rather then just one. No, just one in 4.0.x. You have to use 4.1.x for multiple character sets. _ Let t

Character sets

2004-01-29 Thread Ligaya Turmelle
I am running a 4.0.15 database and I need a table to ba able to handle Japanese, Korean, and English at the least. How can I get the database to accept these multiple character sets. I understand the "default character set" option but can I set multiple "default character

Re: Using multiple character sets (Russian & English)

2003-09-02 Thread Rachel Rodriguez
Egor, Thank you for the response. You are the perfect person to answer my questions regarding Russian character sets. :) I two follow-up questions: 1. Will this work even though I am using two different character sets? I just want to be clear on what I am describing: one column of my table

Re: Using multiple character sets (Russian & English)

2003-09-01 Thread Rachel Rodriguez
since this is my first time trying this. I have an off-topic question for those on the list that use scripts with mixed character sets for the values: Our MySQL server is running on Linux, but I am doing my development on Windows 2000. I want to now create a .sql script to issue all of my commands to

Re: Using multiple character sets (Russian & English)

2003-09-01 Thread Egor Egorov
Rachel Rodriguez <[EMAIL PROTECTED]> wrote: > > I have experience using MySQL and SQL commands in > general, but I am going through my first experience > with working with multiple character sets. > > I am working on a Russian/English translation project > and I

Using multiple character sets (Russian & English)

2003-08-30 Thread Rachel Rodriguez
Hello, I have experience using MySQL and SQL commands in general, but I am going through my first experience with working with multiple character sets. I am working on a Russian/English translation project and I'd like to create a table where column1 contains words in Russian and co

Re: Changing character sets and 'myisamchk -dvv'

2002-11-13 Thread stantz
> At 23:23 -0500 11/12/02, <[EMAIL PROTECTED]> wrote: >> The MySQL documentation (4.6.1) says: >> You can change the character set with the --default-character-set option >> when you start the server. The character sets available depend on the >> --with-charset=

Re: Changing character sets and 'myisamchk -dvv'

2002-11-13 Thread Paul DuBois
At 23:23 -0500 11/12/02, <[EMAIL PROTECTED]> wrote: The MySQL documentation (4.6.1) says: You can change the character set with the --default-character-set option when you start the server. The character sets available depend on the --with-charset=charset and --with-extra-ch

Changing character sets and 'myisamchk -dvv'

2002-11-12 Thread stantz
The MySQL documentation (4.6.1) says: > You can change the character set with the --default-character-set option > when you start the server. The character sets available depend on the > --with-charset=charset and --with-extra-charsets= list-of-charset | complex > | al

re: Character-sets

2002-11-07 Thread Egor Egorov
nt character set in table, column names: http://www.mysql.com/doc/en/Legal_names.html Unfortunatly MySQL doesn't have arabic character set, in this case you can use `` around table names. MdB> Can I mix two character-sets (English and Arabic) in MdB> the same database, or does i

Character-sets

2002-11-06 Thread Michelle de Beer
If I want to create a database with an arabic character-set, will only the data-cells be affected by this or will the table names, column names etc also be in arabic? Can I mix two character-sets (English and Arabic) in the same database, or does it have to be in two separate databases? Any

re: mysql server with different character sets per user

2002-11-05 Thread Egor Egorov
company uses the default character set for the mysql NG> server. Is it possible that they let my account use a different NG> character set than the default? I am going to ask them but I would like NG> to know whether it is possible. Thanks. You can it do only in 4.1. If you want to use dif

mysql server with different character sets per user

2002-11-04 Thread Nikolas Galanis
Hello I was wondering about the following: I am hosting an application with a web hosting company and the character set doesn't satisfy me because I am doing some sorting of greek names and the hosting company uses the default character set for the mysql server. Is it possible that they let my

Re: Using tables with 2 different character sets

2002-11-01 Thread Mark Matthews
Mark Lewellen wrote: In the time since this posting, has the capability of using tables with 2 different character sets been added? If so, how is it done? If not, what workarounds have people used? In case 1) above, is it feasible to have multiple servers running, each configured with a

Using tables with 2 different character sets

2002-11-01 Thread Mark Lewellen
use Unicode in this, as Unicode > is not a complete superset of all charset i have to use, > there will be some losses when i convect to other charsets.. >> Aha. so, i think nowhere. >> You can't do that. In the time since this posting, has the capability of usin

Perl and mySQL and character sets.

2002-09-22 Thread Shaun Bramley
Hello all, I am currently using perl to import some information into a mysql db. At this point in time I have two issues: 1. The text files that are being imported contain both english and french text. My text editor (textpad) gladly displays the text with all proper hyphens and accentuated c

Re: Errors catalog, character-sets-dir .

2002-05-01 Thread Joel Rees
ribution, but I haven't looked. Of course, you could always use this as your excuse for getting into *NIX. ;-> > Also I installed mysql on my D drive and I'm running with > default-character-set=dos. > In the my.ini file, I added a section [client] and I defined > character

Errors catalog, character-sets-dir .

2002-04-30 Thread Frederic Dhorne
nning with default-character-set=dos. In the my.ini file, I added a section [client] and I defined character-sets-dir=d:\mysql\share\charsets. but when I start the client, It continues to look on c:\mysql\\share\charsets. Any information would be great. T

RE: multiple character sets in one database

2002-02-23 Thread Victoria Reznichenko
Chris, Friday, February 22, 2002, 5:40:18 PM, you wrote: CG> Thank you for your very detailed reply. This was my understanding of it too. CG> I guess I was hoping that I had missed something! CG> Do you know when will this happen? (I hate to ask but since I know I will be CG> asked this, I feel

RE: multiple character sets in one database

2002-02-22 Thread Chris Gomez
? Or is there another timeframe? Thanks again. Chris -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 10:16 AM To: [EMAIL PROTECTED] Subject: multiple character sets in one database Chris, Friday, February 22, 2002, 3:51:39 PM, you

multiple character sets in one database

2002-02-22 Thread Victoria Reznichenko
G> Could some please give me advice if this is possible? And if so how? MySQL doesn't support it now, but it is in plans to do full support to the table and query level. You can only use one character set at a time for one instance of mysqld. You need to restart, or start another instanc

multiple character sets in one database

2002-02-22 Thread Chris Gomez
Hello I would like to know how to use different languages in different tables (one language/character set per table). The idea being users can view web page data in their own language. Some of this content will need to be sortable. For example: - english - french - russian - japanese I am new t

Problem with multiple character sets and searching

2001-10-04 Thread Jani Tolonen
[EMAIL PROTECTED] writes: > I have a table in a mysql database that contains data from two > different languages using two different character sets. I need to be > able to query in either language. Queries that I run against the data > in English seem to run fine. Howe

Problem with multiple character sets and searching

2001-09-30 Thread dsuna
I have a table in a mysql database that contains data from two different languages using two different character sets. I need to be able to query in either language. Queries that I run against the data in English seem to run fine. However, queries against the data in the other language give

Adding in character sets

2001-09-12 Thread dsuna
Is there a way to add support for additional character sets to an existing mysql installation without recompiling? I am currently running mysql 3.23.32 if I do need to recompile should I get the source for 3.23.32 or should I already upgrade to 3.23.42? Thanks, David Suna [EMAIL PROTECTED

character sets

2001-07-25 Thread Paul Kelly
hi all, I'm having a problem wrt character sets in mysql. i'm trying to add the euro symbol to a table (MyISAM), but it seems that it is being replaced with '?'. Having looked into the problem a bit, I assume it is that the table is using the default latin1 chara

re-compile mysql to use multiple character sets (again)

2001-07-19 Thread Pjotr Nyikolajevics Szekszardi
Hi, I have configured mysql using the parameter --with-charset=latin2, made some databases and tables full of latin2 text. Now I have to add another database, which will store text in latin1. As I red the articles related to these problems, if I understand well, I have to do the followings: - shu

re-compile mysql to use multiple character sets

2001-07-17 Thread Pjotr Nyikolajevics Szekszardi
Hi, I have configured mysql using the parameter --with-charset=latin2, made some databases and tables full of latin2 text. Now I have to add another database, which will store text in latin1. As I red the articles related to these problems, if I understand well, I have to do the followings: - shu

Character sets!!

2001-06-14 Thread Stefán Jökull Sigurðarson
I was wondering if there were any good instructions somewhere on how to make custom character sets for MySQL. Is it necessary to compile them into the database and are the values in the arrays ASCII character values or maybe Unicode? Thanks in advance! Stefán Jökull Sigurðarson - Programmer

ATTENTION: bug fix for Innobase non-latin1 character sets

2001-03-18 Thread Heikki Tuuri
Readers of the mailing list! There is a serious bug in the non-latin1 character set support of Innobase. The bug causes indexes to be sorted in a wrong order, and queries to return wrong results. The bug explains why test-ATIS returned wrong results in a Russian installation. I assumed that the

Compiling MySQL for other character sets

2001-02-15 Thread FCP Wong
Hi all, Would like to ask a few questions on how to go about compiling support for a multibyte character set into MySQL. When I compile by default without specifying any character sets, it's supposed to compile in ALL character sets. Yet, when I try to run a mysql daemon that was compil

character sets error

2001-02-05 Thread TM Safar Tibor Leo
Hi, I work under WinNT with MySQLODBC cilent, and the mySQL server is installed to the linux server. I receive an error message: 'can't initialize character set 21 (path: c:\mysql\\share\charsets)'. I use the hungarian character set, and I try to put in the showed location the hungarian.conf fi

character sets error

2001-02-05 Thread TM Safar Tibor Leo
I work under WinNT with MySQLODBC cilent, and the mySQL server is installed to the linux server. I receive an error message: 'can't initialize character set 21 (path: c:\mysql\\share\charsets)'. I use the hungarian character set, and I try to put in the showed location the hungarian.conf file bu

Re: 2 character sets at the same time

2001-01-16 Thread Rolf Hopkins
ne so. - Original Message - From: "WCBaker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 16, 2001 19:22 Subject: 2 character sets at the same time > Hi! > > I would like to be able to use BOTH Japanese characters and English in > mySQL. I am

  1   2   >