Hello,
I use mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486)
using readline 5.2.

I created database:
CREATE DATABASE ogloszenia CHARACTER SET latin2 COLLATE
latin2_general_ci;

Then I imported database tables with data from .sql script created by
another MySQL. I use latin2, Polish characters.

Unfortunately, instead of Polish characters I have question marks.

Please help. Thanks in advance.

On 11/11/2010 8:05 PM, Jivanmukta wrote:
Where do you see the question marks? What charset are you using to
display the data?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

mysql> select * from offer_types;
+---------------+-----------------+
5 rows in set (0.00 sec)

Instead of 'sprzeda?' there should be 'sprzedaż'.

On 11/11/2010 9:44 PM, Jivanmukta wrote:
What about the rest of my post?

What charset are you using to display data? And since you're using the
cli, what's the charset used for the connection? (the same can be asked
of when you store the data).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

On Thu, 11 Nov 2010 18:44:50 -0800 (PST), Jivanmukta wrote:
Does your terminal support Latin2? Obviously, mine doesn't...

--
The pluses in my current job include laughing in the face of Nobel
laureates who have just lost the only copy of their data. (Hey,
I'm still a BOFH).
-- Bob Dowling

On WWW page I use ISO-8859-2. This is latin2 Polish.

I am not sure if I understand you but I used command:
mysql -u root -p --default-character-set=latin2

I don't know how to check this.
But I have question marks instead of latin2 in a WWW browser, too.

I mean texts in HTML paragraphs are displayed correctly with latin2
characters. The problem concerns drop-down lists filled in with data
taken from database: there are quotation marks.

Jivanmukta <jivanmukta (AT) poczta (DOT) onet.pl> wrote:

Are you aware that a character set / collation specified for a database
is just a *default*?

Those tables and the columns in them can use completely different
encoding. SHOW CREATE TABLE ... or SHOW FULL FIELDS FROM ... will tell.

RTFM. At least this page:
http://dev.mysql.com/doc/refman/5.0/...onnection.html

but better the whole chapter about character set support.


XL

On Nov 12, 11:39*am, Axel Schwenke <axel.schwe... (AT) gmx (DOT) de> wrote:
I recreated my database setting SET NAMES latin2 COLLATE
latin2_general_ci before, but it didn't help.