charset

How can I set the characterset to latin5 for mysq4 in linux? OKAN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

charset

Hi, I have this database with utf-8 charset. How can i change it to latin1 ? I've seen the MySQL pages and run in the MySQL prompt: ALTER DATABASE telbit CHARACTER SET latin1 COLLATE latin1_swedish_ci; but i get an error saying that i have an error in my syntax. Any help would be apprec

charset

Hello, I'm having really strange problems with characters when retrieved to Java from MySQL. On some columns (or if it is in some tables) it works, in others it do not. I have checked what charset Java thinks it should be, and that is cp1252 in both cases. I've checked the lis

Charset problem

Hi, sometime ago my boss imported a dump into a base using Cocoa MySQL on Mac. Unfortunatly he switch the charset from ISO-8859-1 to something wrong, probably UTF-8. From this time we have such weird characters in our fields : FerrandiËre instead of Ferrandière, CitÈ instead of Citée and so on

MySQL charset

HI, I have a client that runs php+mysql application and it has a problem with "ORDER BY some_varchar_field" sql expression. The DB is in russian cp1251 encoding and "order by" doesnt produce an alphabetically ordered result. our mysql server default charset is latin1 and

Charset issue

hi all. Here is the suituation. i've installed mysql 4.1.12 on WinXP plantform, it seems not to support Chinese by its default configuration, say, Chinese can't be displayer propely. as far as i know, what i need to do is modify the charset(server, connection, client...)concerned, but

Charset issue

Hi, I've installed MySQL 4.1.10 and phpMyAdmin-2.6.4-rc1 on a RHEL4 box. And I found that phpMyAdmin forces the character set of pages utf-8. Though I knew that phpMyAdmin-2.5.7 can work well with gb2312, I want to make phpMyAdmin work well too. Anybody knows that how to make phpMyAdmin work with

Setting charset

For Archivum My destination was: Changing default latin1 charset to latin2 and the default collation to latin2_hungarian_ci. I tried to configure accross my.cnf, but all of my effort failed. I installed mysql-administrator, use startup paramters in. Change mysqldump . Took changes and

Re: charset

Hello. In case mysql4 is mysql4.0 there should be a server system variable default_character_set. If it is 4.1 see: http://dev.mysql.com/doc/refman/4.1/en/charset-syntax.html http://dev.mysql.com/doc/refman/4.1/en/charset-connection.html OKAN ARI wrote: > How can I set the characterset

Re: charset

yes it is mysql 4.0 how can I set i to latin 5 or how can I set the server to latin 5? os: centos 4.2 Thank you - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: Sent: Tuesday, January 31, 2006 1:40 PM Subject: Re: charset Hello. In case my

Re: charset

;character_sets'; statement. OKAN ARI wrote: > yes it is mysql 4.0 how can I set i to latin 5 or how can I set the > server to latin 5? > > os: centos 4.2 > > Thank you > - Original Message - From: "Gleb Paharenko" > <[EMAIL PROTECTED]> > To: &

Charset questions

some ColdFusion functions. I am wondering if my database charset has anything to do with it. What do other people usually do as far as the collation setting? We are in the US, but do have a few sites that make use of German and Spanish characters. Thanks, -Ryan -- MySQL General Mailing List

About charset

Hello list, I have a table whose 'default charset=utf8'. I insert a record into it with non-utf8 charset,like GBK.Then I select this record,it print GBK characters correctly. Then I insert a utf8 record into it,and read this record in scripts and decode it with utf8_decode,the resu

Re: charset

Hi, Try the format below: ALTER DATABASE mybase DEFAULT CHARACTER SET = latin1; ALTER DATABASE mybase DEFAULT COLLATE = latin1_swedish_ci; HTH ... - Original Message - From: "Mário Gamito" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Monday, April 09, 200

charset order

Hell o all. I edit the my.cnf file addinn a line default-character-set=value and then i try to reindex the tables according to the manual: (If you change the character set when running MySQL (which may also change the sort order), you must run myisamchk -r -q on all tables. Otherwise your indexe

Japanese Charset

L, for example: Microsoft IIS or ASP or MyODBC? Question 3. How do I tell which charset MySQL is using, euc-jis or s-jis? Sincerely, Dawn Friedland [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manua

language charset

Hello Folks I am so far using japanese characters with mysql without any problem. But today when I try to insert some japanese characters, only one character get truncated to a . (dot) mark. How can I set the default charset in the .cnf or .ini file ? With MyISAM, I used to set in the mysql

different charset

Hi, is it possible to use differenet character sets on one mysqld, couse i need to sort data in tables using my character set but not only i want to do this stuff in for example latin1 character set... Jurgis - Before

Re: charset

löijer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 2:16 PM Subject: charset Hello, I'm having really strange problems with characters when retrieved to Java from MySQL. On some columns (or if it is in some tables) it works, in others it do

Chinese charset

Is it possible to use MySQL with a chinese charset (utf8) ? If not, what do you suggest to do if I want to develop a database for a chinese web site ? thanks - Before posting, please check: http://www.mysql.com/manual.php

default connection charset

Hi, I have mysql 4.1.12 started with the default charset 'koi8r' and I have the following problem: when connecting from PHP, the default results and connection charsets become latin1, so all not-latin characters get lost (they are displayed as ?). Of cause, if I explicitely

Re: MySQL charset

Privet! Yogesh wrote: HI, I have a client that runs php+mysql application and it has a problem with "ORDER BY some_varchar_field" sql expression. The DB is in russian cp1251 encoding and "order by" doesnt produce an alphabetically ordered result. our mysql server defaul

Re: Charset issue

Hello. > Chinese can't be displayer propely. What client do you use to connect to MySQL Server? Check that it supports Chinese. I don't know Chinese and can't suggest what character to use. But, certainly, you should choose one from: http://dev.mysql.com/doc/mysq

RE: Charset questions

> This was based on digging through the manual and google. But > now I am migrating the application to a newer version of > ColdFusion and am running into some issues with charsets on > some ColdFusion functions. I am wondering if my database > charset has anything to do with it.

RE: Charset questions

on to a newer version of ColdFusion and am >> running into some issues with charsets on some ColdFusion functions. >> I am wondering if my database charset has anything to do with it. >> >> What do other people usually do as far as the collation setting? >> &

RE: Charset questions

> default as far as collations - latin1_swedish_ci. > >> This was based on digging through the manual and google. But now I am > >> migrating the application to a newer version of ColdFusion and am > >> running into some issues with charsets on some ColdFusion functi

Re: Charset questions

* specific on your problem. What is the server default charset and collation ? What is the database default charset and collation ? What charsets and collations are the tables and/ or even the columns you were talking about ? Finally I didn't found any ColdFusion secific connector... so I assume

Current server charset?

Hi, In MySQL 4.1, is there a function to know what the current default server-wide characterset is? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For lis

utf8 charset question

nd a text field where the table has been defined to use : ENGINE=ndbcluster DEFAULT CHARSET=latin1 Now, through my php user interface, I find that I can update/insert Korean characters into the database table and successfully retrieve them from the database. I'm using microsoft'

charset big5 support

dear sir: I use mysql 3.22 for a long time, it seems ok on our native language traditional chinese, charset big5. I use '--with-charset=big5' as the only one configure parameter, but when I use it on 3.23.32, the client will yield this error message: -- File 'NONEXISTENT/

Arabic Charset support.

Hi all, When will Arabic charset be included as a supported charset? Anyone solved this problem? sql : this word is needed by the lists filter. Waheed - Before posting, please check: http://www.mysql.com/manual.php (the

Charset Question - Spanish?

columns in question are al= l created as VARCHAR and BINARY is not set for those columns. My default charset is Latin1. Other charsets installed are: latin1=A0dec8=A0dos=A0german1=A0hp8=A0koi8_ru=A0latin2=A0swe7=A0usa7=A0cp1251=A0danish=A0hebrew=A0 win1251=A0estonia=A0hungarian=A0koi8_ukr=A0

mysql default charset

Hi, How can I set my mysqld-nt.exe to run different charset for example cp1251. I tried mysqld-nt.exe --default-charset-set=cp1251 but it started second instance of mysqld-nt and my MySQL did not order correctly cyrillic. Any help apreciated. SaS

Re: Japanese Charset

set up right. Say, how are you declaring your doctype? You know, the Content-Type header or meta-tag, or the XML doctype. See: HTML: http://www.w3.org/TR/html4/charset.html#h-5.2.2 Header: Content-Type: text/html; charset=EUC-JP or Meta-tag: XML: ht

RE: Japanese Charset

Thank you for your time and response. I have checked if the text is surviving the paste buffer - it is. (I did a character by character comparison of the text one pasted in the web form, but before hitting submit.) The problem characters are the ASCII backslash and the ASCII tilde - Good to kno

Re: Japanese Charset

... > The problem characters are the ASCII backslash and the ASCII tilde - > Good to know, I will eliminate those, although there are still many more > problem characters. Well, actually, the one-byte backslash and tilde you can leave alone. They survive intact, they just display differently ov

Re: Japanese Charset

<[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: Japanese Charset >Date: Fri, 20 Sep 2002 16:25:29 +0900 > >... > > > The problem characters are the ASCII backslash and the ASCII tilde - > > Good to know, I will eliminate those, although there are stil

RE: Japanese Charset

Hi Xuefer, What are you talking about? A lot of people are using MySQL without any problems with multibyte characters. Please post a reference URL, with perhaps a detailed explanation of the problem -- you mentioned you have brought this to the attention of people already, please post a relevant

Re: Japanese Charset

;>From: Joel Rees <[EMAIL PROTECTED]> >>To: "Dawn Friedland" <[EMAIL PROTECTED]> >>CC: [EMAIL PROTECTED] >>Subject: Re: Japanese Charset >>Date: Fri, 20 Sep 2002 16:25:29 +0900 >> >>... >> >>> The problem characters are the

Re: Japanese Charset

yes, when i post a problem, someone told me to give more info when i post the whole php-script, no response mysql-4.x unable to handle binary data when using multibyte charset, (maybe the old mysql-3.x escape/unescape is fine) file: mysql-4.0.1-alpha/libmysql_r/libmysql.c in function

RE: Japanese Charset

I hope you will recognize that what you stated as a problem is _not_ what this thread was about. You are talking about -- (a) A new (and as yet non-universal) version of MySQL (b) Only binary data (c) Conf done by you, which is not standard Whereas the thread was about simple Japanese

RE: Japanese Charset

i'm sorry that i've not read through nor understand the whole thread >From: "Shashank Tripathi" <[EMAIL PROTECTED]> >To: "'xuefer tinys'" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>

RE: Japanese Charset

Here's a brief summary of where we are: I trying to store Japanese text (Shift_Jis) in MySQL and view it from a web page. The content is provided to me in Word format. I convert it to plain text, copy/paste into a web form in an ASP-based CMS on a Windows box. When viewed from a web page, seemin

Re: Japanese Charset

wrote a small bean component. This component will read the characters(Shift_JIS , a,b or any) and convert into (8859_1) and put it into the database While retrieving the data, I will do the reverse. Also make sure the right charset is set in your html page My knowledge in asp is a big zero. So if you

Re: Japanese Charset

Dawn, Look at chapter 6.1.1.1 in the MySQL docs: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Literals Practically the first odd thing mentioned is escape sequences. Keep in mind that the ASCII code for the backslash character, which is used to initiate escape s

RE: Japanese Charset

Here's an update on this issue: The problem is when copy/pasting Japanese characters into MySQL, certain characters are being corrupted. I've ruled out Word as the problem. I've ruled out my content tool as the problem. I've ruled out the ASP display page as the problem. I've configured my Reg

Re: Japanese Charset

> Lastly, I am convinced that this is a problem with MySQL. I have some time again, let me try again. It's a tortuous tale, but bear with me. Background in brief: Shift-JIS is a real pain in the neck to parse. When you look at a byte, it's often impossible to tell whether you're looking at the

Re: Japanese Charset

Joel Rees wrote: >Shift-JIS is a real pain in the neck to parse. When you look at a byte, >it's often impossible to tell whether you're looking at the first byte >or the second byte of the character. > Can I make a minor recommendation that doesn't help your current situation at all? Use UTF-8.

Re: Japanese Charset

Dawn Friedland wrote: >Prior to my client requesting that I add Japanese content to the content >tool & database, I had zero experience with characters sets other than >Latin. I always used notepad to filter out any weird MS Word formattings >and left the default as ANSI. > I had that problem a

Re: Japanese Charset

ranslations, then read it when you need it and compare > it against something if necessary and display it. Just because it > looks like garbage when its raw doesn't mean it _is_ garbage. > I've read lots of similar posts in the archives at <http://lists.mysql.com/>. Many sugge

RE: Japanese Charset

Japanese) instead of this > kludge? If I compile MySQL to support UJIS with --with-charset=sjis > won't text fields then store ujis encoded text properly? I'd like to > use Unicode too but if it's not supported yet... The idea is to be able to store Latin and Japanese in the

Re: Japanese Charset

text field. But MySQL supports double-byte languages. Why not use an > > encoding it supports (SJIS or UJIS for Japanese) instead of this > > kludge? If I compile MySQL to support UJIS with --with-charset=sjis > > won't text fields then store ujis encoded text proper

Re: Japanese Charset

Joel Rees wrote: >>If I compile MySQL using --with-charset=sjis , how will it handle the >>Latin, Chinese, and Korean characters? >> >> > >Multiple databases on multiple servers? > Try this one on for size: CREATE TABLE Customers ( Name VARCHAR(100) )

RE: Japanese Charset

problem.) Thanks for all your help. I feel much less hopeless than I did several weeks ago. Dawn Friedland [EMAIL PROTECTED] > -Original Message- > From: Joel Rees [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 29, 2002 7:24 PM > To: Dawn Friedland > Cc: [EMAIL PROTECTED]

RE: Japanese Charset

[mailto:[EMAIL PROTECTED]] > Sent: Monday, September 30, 2002 5:35 AM > To: Joel Rees > Cc: Dawn Friedland; [EMAIL PROTECTED] > Subject: Re: Japanese Charset > > > Joel Rees wrote: > > >>If I compile MySQL using --with-charset=sjis ,

Re: Japanese Charset

y/paste >directly to command prompt. Characters still break. > >Thanks for your input. I am welcome to hearing more ideas. Perhaps I am >missing something (likely). >Dawn > > > >>-Original Message- >>From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] &g

RE: Japanese Charset

was so simple: one line of code. Sincerely, Dawn Friedland [EMAIL PROTECTED] > -Original Message- > From: gerald_clark [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 30, 2002 1:16 PM > To: Dawn Friedland > Cc: Michael T. Babcock; [EMAIL PROTECTED] > Subject: Re:

Re: Japanese Charset

> > Multiple databases on multiple servers? > That is what I thought...which I assume means multiple machines (not an > option). For future reference, MySQL can actually run multiple servers with different configurations on a single machine in Linux. (*BSD and Mac OS X, too, I think.) They are wo

Re: Japanese Charset

> I found a solution!!! Hooray! > ***Replace all backlashes with two backslashes.*** You probably want to consider whether you want to replace all quotes with backslash-quote, as well. Backslashes in the English text would only show up for something like file paths on MS OSses, but your custome

Re: Japanese Charset

I was not aware that you were running VB. In perl and PHP we have a function do do this for us. in perl: $qtext=$dbh->quote($text); $dbh->execute("insert into mytable set myvariable = $qtext"); The above quote() function will put a \ in fronnt of all the special characters listed in the manual.

Re: Japanese Charset

gerald_clark wrote: > $qtext=$dbh->quote($text); > $dbh->execute("insert into mytable set myvariable = $qtext"); > > The above quote() function will put a \ in fronnt of all the special > characters listed in the manual. > These in clude "'\ and the hex 00 character. FWIW, before anyone copies

Re: Japanese Charset

It is already quoted. That's the point. Michael T. Babcock wrote: > gerald_clark wrote: > >> $qtext=$dbh->quote($text); >> $dbh->execute("insert into mytable set myvariable = $qtext"); >> >> The above quote() function will put a \ in fronnt of all the special >> characters listed in the manual

re: language charset

kayamboo, Tuesday, October 15, 2002, 12:31:39 PM, you wrote: k> I am so far using japanese characters with mysql without any problem. k> But today when I try to insert some japanese characters, only one character k> get truncated to a . (dot) mark. k> How can I set the default ch

Re: language charset

. Will this affect the charset structure for japanese 2. Secondly I created a table CREATE TABLE PLOT_DB( plotname VARCHAR(5) NOT NULL PRIMARY KEY ) TYPE = INNODB ; When I insert japanese alphabets of size 1 from a text file, it throws error--> primary key violation. ( the characters I

unicode charset support ?

hi mysql guru's, does anyone put light on the unicode charset support of MYSQL? i searced everywhere in the archives and the docs , but couldn't find a related thing.It seems that it doesn't support, however i am asking you to be sure. My application needs to save both japan

Re: different charset

cter set... You need to use two charset at the same time ? If you need just to swap charsets - look here http://www.mysql.com/doc/C/h/Character_sets.html ___ For technical support contracts, visit https://order.mysql.com/ This email

Charset=latin1 problem

SQL syntax near 'CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='Inneholder abonnementdata'' at line 38 (113 ms taken) The create table query is as follows CREATE TABLE `abonnenter` ( `id` int(11) NOT NULL auto_increment, `navn` varchar(100) NOT NULL default '',

charset=latin1 problem

SQL syntax near 'CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='Inneholder abonnementdata'' at line 38 (113 ms taken) The create table query is as follows CREATE TABLE `abonnenter` ( `id` int(11) NOT NULL auto_increment, `navn` varchar(100) NOT NULL default '', `abonr

Re: Chinese charset

> Is it possible to use MySQL with a chinese charset (utf8) ? You need to use BLOB or TEXT types and do a little bit of work yourself to manage them, but basically it does work fine. mySQL just treats it as binary data. -

Re: default connection charset

Privet. As I know, PHP usually takes the character set from the server. Please send part of your configuration file related to character sets. Varshavchick Alexander <[EMAIL PROTECTED]> wrote: > Hi, > > I have mysql 4.1.12 started with the default charset 'koi8r

Charset and collation question

Hi all, Which charset and collatio would be the most suitable for a french / english system? Thanks Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Replication, charset / collations Problem

Hi, I try to replicate an existing database to a new server and run into trouble with collations. Maybe somebody can help me. Existing DB-Server (Master): MySQL Version 4.1.12 ca. 100 GB Database size. New DB-Server (Slave): MySQL Version 4.1.12 Here is what I did to get the replication up and

回复： Charset issue

suituation. i've installed mysql 4.1.12 on WinXP plantform, it seems not to support Chinese by its default configuration, say, Chinese can't be displayer propely. as far as i know, what i need to do is modify the charset(server, connection, client...)concerned, but i'm not so su

Re: Current server charset?

On Tue, 6 Jan 2004, Martijn Tonies wrote: > Hi, > > In MySQL 4.1, is there a function to know what the > current default server-wide characterset is? You can find all those with: SHOW VARIABLES LIKE 'character_set%' cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.m

Re: Current server charset?

Hi Tobias, > On Tue, 6 Jan 2004, Martijn Tonies wrote: > > > Hi, > > > > In MySQL 4.1, is there a function to know what the > > current default server-wide characterset is? > > You can find all those with: > SHOW VARIABLES LIKE 'character_set%' Thanks, that'll do the trick. Is there any reason

MySQL 4.0.x charset

Hello, How can I see what char set is being used as the default char set on the server or database? Also, is there a way to change the default setting? Thanks, Yves __ Post your free ad now! http://personals.yahoo.ca -- MyS

help about the charset

Hello, I have a strange problem on the charset on mysql. I'm using mysql-5.0.45, compiled from the source, and enabled: '--with-charset=utf8' '--with-extral-charsets=all' when compiling it. My default charset in my.cnf is utf8: character-set-server=utf8 OK I logined i

Re: charset big5 support

Hi Silver I've never tried changing character sets myself but you did download the right version and I mean source not binaries of 3.23.32? You know you can also get away with using the default charset as Chinese chars are sorted in ASCII anyway. Only problem is, you need a Chinese fron

Re: Charset Question - Spanish?

s, but surely there is a better solution! Reid [EMAIL PROTECTED] -- >From: Juergen Schreck <[EMAIL PROTECTED]> >To: MYSQL List <[EMAIL PROTECTED]> >Subject: Charset Question - Spanish? >Date: Mon, Feb 11, 2002, 1:33 PM > > Hi, > > I've read t

Re: mysql default charset

Go to mysqlAdmin Go to my.ini setup add language = MYSQL_HOME/share/your_language_here Save the changes Hope this will help regards KayambooSuresh At 11:33 Χ΋ 02/09/01 +0300, you wrote: >Hi, >How can I set my mysqld-nt.exe to run different charset >for example cp1251. >I

Re: mysql default charset

will help > >regards >KayambooSuresh > > > > > >At 11:33 'ß'ã 02/09/01 +0300, you wrote: >>Hi, >>How can I set my mysqld-nt.exe to run different charset >>for example cp1251. >>I tried mysqld-nt.exe --default-charset-set=cp1251 >>but it st

Re: mysql default charset

Alexander, Sunday, September 01, 2002, 11:33:56 PM, you wrote: AP> How can I set my mysqld-nt.exe to run different charset AP> for example cp1251. Currently you can't use different character sets with one MySQL server. AP> I tried mysqld-nt.exe --default-charset-set=cp1251 AP&g

New charset for MySQL

Dear sir, I want to create a website in my native language. I would like MySQL support for my native character set, which is Bengali. I think MySQL does not support this language. How can I add support for it in MySQL ? Thanks in advance for any reply. Shyamal -

Problem adding new charset

Hi, I am trying to add new charset in my preinstalled mysql-3.23.26-beta. Manual says: Add the character set name to the CHARSETS_AVAILABLE and COMPILED_CHARSETS lists in configure.in. But I CAN NOT find COMPILED_CHARSETS list there. Please help me. Regards, Ivan Lulukyan

Re: about big5 charset

some time, and the necessary files should be in place. The file you need to edit (or make) for MSWinjunk is probably C:\WINNT\my.ini. Look over the manual carfully. -- Joel Rees <[EMAIL PROTECTED]> Ben Koo inquired > Dear Sirs, > > would you mind to tell me how to add "big5

Re: default connection charset - SOLVED

rted with the default charset 'koi8r' and I have the following problem: when connecting from PHP, the default results and connection charsets become latin1, so all not-latin characters get lost (they are displayed as ?). Of cause, if I explicitely set these charsets to koi8r in the PHP scripts af

charset latin1_de removed in 4.1.4?

Hello, in 4.0.20 I was happy that German Umlauts are sorted correctly (ä -> ae, ö -> oe, ü -> ue). With 4.1.4 the configuration stops: checking "character sets"... configure: error: Charset 'latin1_de' not available. (Available are: binary ascii armscii8 ascii big5

Re: Charset and collation question

Hello. Similar question has been asked already. See: http://lists.mysql.com/mysql/179154 "Stephane Savage" <[EMAIL PROTECTED]> wrote: > Hi all, > > Which charset and collatio would be the most suitable for a french / > english system? > > Tha

Re: Replication, charset / collations Problem

> The only idea, which came into my mind, is that the server use different > default charsets or collations. I checked the configurations and can't > find a difference. Is there a possibility to check the default charsets > and collations on the running server ? If charsets/collations are not set

Re: Replication, charset / collations Problem

Am Dienstag, den 09.08.2005, 17:57 +0400 schrieb Alexey Polyakov: > If charsets/collations are not set explicitly in my.cnf, server could > be using ones specified during compilation. > To check charsets and collations on the running server do: > show global variables like 'c%'; Thanks. I execute

Re: Replication, charset / collations Problem

Hello. Please, send the output of the following statement executed both on master and slave: show variables like '%char%'; Send the definition of your table as well: SHOW CREATE TABLE sum_day_key_requests; Marco P$hler <[EMAIL PROTECTED]> wrote: > Hi, > > I try to repl

Re: Replication, charset / collations Problem

NULL default '', `afftraf` varchar(5) character set latin1 collate latin1_bin NOT NULL default '', `sum` int(10) unsigned NOT NULL default '1', PRIMARY KEY (`day`,`type`,`client`,`channel`,`campaign`,`grouping`,`key`,`afftraf`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1

Re: Replication, charset / collations Problem

haracter set latin1 collate latin1_bin NOT > NULL default '', > `grouping` varchar(64) character set latin1 collate latin1_bin NOT > NULL default '', > `key` varchar(255) character set utf8 collate utf8_bin NOT NULL > default '', > `afftraf` va

Charset problems (utf-8 -> latin1)

ING latin1) FROM old_db.table; When doing a SELECT CHARSET(field) FROM new_db.table; It returns "latin1", so everthings seems to be A-Okay - but since I'm posting this message you could prolly guess that it didn't - and right, it failed... Using SSH to the mysql-server, and us

A new charset without recompiling

Can I put a new charset or modify an existing one without recompiling MySQL? If yes, please tell me how. Thanks Anticipated, Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4.0.x charset

You can see it by executing the "SHOW VARIABLES" query on your server. You will find the used charset in the 'character_set' variable. You can also use the query "SHOW VARIABLES LIKE 'character_set'" which will directly match what you want. Yves wrot

Re: MySQL 4.0.x charset

amount of lines.. thanks, Yves A --- Jean-Marc PULVAR <[EMAIL PROTECTED]> wrote: > You can see it by executing the "SHOW VARIABLES" > query on your server. > You will find the used charset in the > 'character_set' variable. > > You can also use the

Re: MySQL 4.0.x charset

on your server. You will find the used charset in the 'character_set' variable. You can also use the query "SHOW VARIABLES LIKE 'character_set'" which will directly match what you want. Yves wrote: Hello, How can I see what char set is being used as the default cha

Charset for SELECT ... INTO OUTFILE

Hi, I have a database where the database character set is utf-8 and some rows are ascii. I want to save the results of some queries, and SELECT ... INTO OUTFILE looks like an easy way to do it. But I need the output in ucs-2. Is there any way to specify the charset for SELECT ... INTO OUTFILE

ENGINE=InnoDB DEFAULT CHARSET=latin1;

Hello, I am getting an error #HY000Incorrect string value: '\xE9l\xE9tra...' for column ' Not quite sure why. hex E9 is a lower case e acute found in CP1252 and googling seems to tell me that the latin1 charset that I have set for the table should display this OK. mysql V 5.

  1   2   >