Hi,
Thanks for your clue. Please provide me with additional details as to how
should I go about doing this (making Mysql use MacRoman encoding).
1)About compiling a particular character set with mysql, the manual says:
MYSQL MANUAL: shell> ./configure --with-charset=CHARSET
CHARSET may be one of big5, cp1251, cp1257, czech, danish, dec8, dos,
euc_kr, gb2312, gbk, german1, hebrew, hp8, hungarian, koi8_ru, koi8_ukr,
latin1, latin2, sjis, swe7, tis620, ujis, usa7, or win1251ukr.
MacRoman is not listed here.
2)For using the SET OPTION CHARSET, the manual says...
MYSQL MANUAL: CHARACTER SET character_set_name | DEFAULT
This maps all strings from and to the client with the given mapping.
Currently the only option for character_set_name is cp1251_koi8, but you can
easily add new mappings by editing the `sql/convert.cc' file in the MySQL
source distribution. The default mapping can be restored by using a
character_set_name value of DEFAULT. Note that the syntax for setting the
CHARACTER SET option differs from the syntax for setting the other options.
Again, I don't know if that is the clue that I should follow and can
MacRoman be enabled by that.
3)For using Charset definition files as suggested as the third solution in
the manual, please provide me some lead as to how to do that.
MYSQL MANUAL: The character sets available depend on the
--with-charset=charset and --with-extra-charset= list-of-charset | complex |
all options to configure, and the character set configuration files listed
in `SHAREDIR/charsets/Index'.
I don't know where to start from and how to get the MacRoman Support. Can
anybody enlighten me on that??
Thanks in advance,
Regards,
Kundan Kumar
------ Forwarded Message
From: Kundan Kumar <[EMAIL PROTECTED]>
Date: Tue, 04 Dec 2001 14:14:06 +0800
To: [EMAIL PROTECTED]
Subject: Loading data file with MacRoman Character Encoding
Hi All,
I am running Mysql version 2.23.42 on Mac OS X version 10.1.
I need to upload few files in Mysql which are in MacRoman Text Encoding. My
default installation does not support the MacRoman Encoding.
Currently I need to convert the file into ISO-8859-1 encoding before I can
run the LOAD DATA INFILE. I am doing this with a text encoding conversion
utility called 'Cyclone'. It is a Cocoa Application with all fancy gui and I
can not run it silently from the shell.
As I move to deploy my database, I would need to upload the files at a
frequency of 5 minutes. Of course, this cyclone trick is not the correct
answer, even with AppleScripts.
What I need to know is:
A) Is there any binary for Mac OS X which supports MacRoman Encoding? Mysql
AB recently released binaries for Mac OS X (3.23.45 and 3.23.46), do these
versions support that?
Any future plans about when it would be in place?
B) I have seen in the manuals about adding custom text encoding definitions
to MySQL. But I am too non-technical to be able to work on that lead. Can
someone point me to helpful documents on that?
This is very important for my project as everything depends on whether I can
even import the data in my database efficiently or not.
Thanks and Regards,
Kundan Kumar
------ Forwarded Message
From: Sinisa Milivojevic <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 5 Dec 2001 16:06:59 +0200
To: [EMAIL PROTECTED]
Subject: Re: FW: Loading data file with MacRoman Character Encoding
Hi!
First :
MySQL can take any encoding as long as it is SBCS (char = 1
byte).
Second :
If you write an email to an individual MySQL developer directly,
please make sure that you have put a Cc to appropriate mailing list
also. If you have a support contract, please state your support id,
support level (type) and expiration date in the beginning of your
E-mail and you can mail (or put a Cc) to [EMAIL PROTECTED]
If you are looking for free support, please consider mailing to a
public MySQL mailing list. You can find all the MySQL related mailing
lists from the MySQL manual under chapter '2. MySQL Mailing Lists'.
The lists are grouped by different operating systems and different
purposes of the lists.
http://www.mysql.com/manual.php?section=Questions
If you did not receive an answer from a public MySQL mailing list,
please verify that you:
- E-mailed your question to the right mailing list.
- Checked that your question is not covered in the MySQL manual.
Search the manual with a couple of keywords at
http://www.mysql.com/documentation/mysql/full/ or
http://www.mysql.com/documentation/mysql/commented/
(Most of the questions asked in the MySQL mailing lists are
covered in the MySQL manual)
- Included enough information in your E-mail. Be aware that
sometimes other MySQL users don't bother answering an E-mail that
doesn't contain all the relevant information, even if they could
have helped otherwise. Same thing, if the question is well covered
in the MySQL manual and is considered as an FAQ.
- Followed the guidelines at
http://www.mysql.com/manual.php?section=Bug_reports
if you filed a problem (bug) report.
When you write to [EMAIL PROTECTED], you will always get an answer to
your E-mail, but you need a valid support contract in order to be
allowed to use this address. This list is monitored by the MySQL
developers and any data sent here stays confidential, unless you give
us permission to use the data publicly (for testing).
If you don't have a support contract and you feel you need one, please
consider purchasing one from https://order.mysql.com/ as described in
http://www.mysql.com/manual.php?section=Licensing_and_Support
If you are in a terrible hurry, need help with MySQL and don't have
time to wait for the support contract, we will help you before you get
your support contract. In this case it is enough that you tell us in
the beginning of your E-mail that you have just ordered a support
(please mention the support level too), we trust your word. Please
consider this as an emergency situation; usually we can handle the
support contracts within a couple of days.
This address ([EMAIL PROTECTED]) is meant only for paying customers.
If you have a support contract, please state your support id, support
level (type) and expiration date in the beginning of your E-mail.
If you are looking for free support, please consider mailing to a
public MySQL mailing list. You can find all the MySQL related mailing
lists from the MySQL manual under chapter '2. MySQL Mailing Lists'.
The lists are grouped by different operating systems and different
purposes of the lists.
http://www.mysql.com/manual.php?section=Questions
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
------ End of Forwarded Message
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
