1

Topic: with the coding in Apache+MySQL+Perl under Windows

2

Re: with the coding in Apache+MySQL+Perl under Windows

Yes, the basis at you formed with  collation and character-set.
Now there is only one way - to write a script which will take the data from one DB with character-set=latin1 and collation=latin1_swedish_ci and on the fly to write them to other DB with correct character-set and collation.

3

Re: with the coding in Apache+MySQL+Perl under Windows

4

Re: with the coding in Apache+MySQL+Perl under Windows

5

Re: with the coding in Apache+MySQL+Perl under Windows

Itself SQL a file in what coding? Look Far Manager or Notepad ++. I with Russian in mySQL had no affairs thank God, but the first that it is necessary to check up it in what coding from a command file are sent

6

Re: with the coding in Apache+MySQL+Perl under Windows

7

Re: with the coding in Apache+MySQL+Perl under Windows

What sense in the twenty first century to battle to codings? Why not to use ?

8

Re: with the coding in Apache+MySQL+Perl under Windows

I use an ancient development environment where  it is not supported, it is necessary to recode in addition files before "start", inconveniently. For example.

9

Re: with the coding in Apache+MySQL+Perl under Windows

FUKS :
I use an ancient development environment where  it is not supported, it is necessary to recode in addition files before "start", inconveniently. For example.

Put in order codings.
If in basis at you it is specified latin, and really lies 1251 then at display in the console there will be a conversion latin-> <the console coding> and Russian letters become .
If at basis the correct coding and in the console all will be displayed correctly is specified.
P.S. The same leapfrog at developers also in due course. Normally to basis write local time of the server though more correctly for a long time already to pass to time with instructions TZ.
Adding from 8/30/2017 15:26:

FUKS :
It what for, and on what to summer?  basis with corrected adjustments not a problem...

In order that character-set and collation are permanently used by operation dataful of a DB.
Even at simple display of request in the console - there is a recoding from character-set, specified at a DB, in the symbol set specified at the console.
If at you somewhere mismatch - characters become .

10

Re: with the coding in Apache+MySQL+Perl under Windows

11

Re: with the coding in Apache+MySQL+Perl under Windows

You should read about character-set and collation to understand / as they influence the data in basis and as character-set and collation are used at data acquisition from basis and their location there.
At reading from basis there is a converting between codings. At basis - latin, at connection - another. Here to you mysql also converts from latin in the connection coding. And then still converts in the console coding if it does not coincide with the connection coding.

12

Re: with the coding in Apache+MySQL+Perl under Windows

So where to read, and what I made not so? All codings set the identical...

13

Re: with the coding in Apache+MySQL+Perl under Windows

FUKS :
So all under Windows, there one coding , and in a table file is visible that the coding .
]

You about what? What one coding?

14

Re: with the coding in Apache+MySQL+Perl under Windows

It where the such? If I open a file in Notepad, there what coding? If I look a file from WinComander' the built in viewer, and in it there is a daw "ANSI (Windows charset)", it is what coding? If a Muscle on "Avstra..." Swears as on '\xC0\xE2\xF1\xF2\xF0\xE0... ', it is what coding? I understand, what even under Windows it is possible to adjust many different codings for different programs, but same does not mean that they by itself are adjusted. Or means?