cancel
Showing results for 
Search instead for 
Did you mean: 

What language is used for checkpoint console messages in non-English versions?

Breck_Carter
Participant
3,243

Do the following server console messages always appear in English, or does the language depend on the installed language of SQL Anywhere 11.0.1?

Starting checkpoint of "ddd11" (ddd11.db) at Fri Jan 21 2011 07:18
Finished checkpoint of "ddd11" (ddd11.db) at Fri Jan 21 2011 07:18

I am writing code to watch for checkpoints by calling sa_server_messages() every once in a while, and I want to tell the "Starting" apart from the "Finished".

I am happy to build in a table of translations... IF I knew what words are actually used 🙂

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

VolkerBarth
Contributor

SQL Anywhere Network Server Version 11.0.1.2427 in a German setup (the same with 12.0.0.2601):

Start des Checkpoints von "ddd11" (ddd11.db) am/um Freitag, 21. Januar 2011 17:05
Setzen des Checkpoints von "ddd11" (ddd11.db) beendet am/um Freitag, 21. Januar 2011 17:05

Graeme will help to translate:)


Volker suggested using dblang.exe, and that works pretty well... except that the result for several languages is not readable, in either the resulting dbeng11 -o file or the result set returned by sa_server_messages. Here are the checkpoint-related excerpts from all the -o files produced after dblang.exe changed the language:

LANG_DE.txt
I. 22.01 05:53:04. Start des Checkpoints von "ddd11" (ddd11.db) am/um Samstag, 22. Januar 2011 05:53
I. 22.01 05:53:04. Setzen des Checkpoints von "ddd11" (ddd11.db) beendet am/um Samstag, 22. Januar 2011 05:53

LANG_EN.txt
I. 01/22 05:54:10. Starting checkpoint of "ddd11" (ddd11.db) at Sat Jan 22 2011 05:54
I. 01/22 05:54:10. Finished checkpoint of "ddd11" (ddd11.db) at Sat Jan 22 2011 05:54

LANG_ES.txt
I. 22/01 05:53:09. Inicio de verificación "ddd11" (ddd11.db) el Sáb, 22 ene 2011 05:53
I. 22/01 05:53:09. Verificación "ddd11" (ddd11.db) completada el Sáb, 22 ene 2011 05:53

LANG_FR.txt
I. 22/01 05:53:14. Démarrage du point de reprise de "ddd11" (ddd11.db) le sam 22 jan 2011 05:53
I. 22/01 05:53:14. Le point de reprise de "ddd11" (ddd11.db) s'est achevé le sam 22 jan 2011 05:53

LANG_IT.txt
I. 22/01 05:53:19. Avvio del punto di arresto di "ddd11" (ddd11.db): sabato, 22 gennaio 2011 05:53
I. 22/01 05:53:19. Terminato il punto di arresto di "ddd11" (ddd11.db): sabato, 22 gennaio 2011 05:53

LANG_JA.txt
I. 01/22 05:53:25. Sat Jan 22 2011 05:53  "ddd11" (ddd11.db) 
I. 01/22 05:53:25. Sat Jan 22 2011 05:53  "ddd11" (ddd11.db)

LANG_KO.txt
I. 01/22 05:53:30. Sat Jan 22 2011 05:53 "ddd11"(ddd11.db)  .
I. 01/22 05:53:30. Sat Jan 22 2011 05:53 "ddd11"(ddd11.db)  .

LANG_LT.txt
I. 01/22 05:53:35. Pradedamas tikrinti "ddd11" (ddd11.db) kontrolinis taškas Šeš, 2011 Sau 22 05:53
I. 01/22 05:53:35. "ddd11" (ddd11.db) kontrolinio taško pabaiga Šeš, 2011 Sau 22 05:53

LANG_PL.txt
I. 22/01 05:53:40. Pocztek punktu kontrolnego "ddd11" (ddd11.db) o Sob 22 Sty 2011 05:53
I. 22/01 05:53:40. Zakoczono punkt kontrolny "ddd11" (ddd11.db) o Sob 22 Sty 2011 05:53

LANG_PT.txt
I. 22/01 05:53:45. Iniciando o checkpoint de "ddd11" (ddd11.db), Sáb, 22 jan 2011 05:53
I. 22/01 05:53:45. Checkpoint de "ddd11" (ddd11.db) terminado Sáb, 22 jan 2011 05:53

LANG_RU.txt
I. 22/01 05:53:51.    "ddd11" (ddd11.db)  ?? 22 ??? 2011 05:53
I. 22/01 05:53:51.    "ddd11" (ddd11.db)  ?? 22 ??? 2011 05:53

LANG_TW.txt
I. 01/22 05:53:56.  "ddd11" (ddd11.db)  Sat Jan 22 2011 05:53
I. 01/22 05:53:56.  "ddd11" (ddd11.db)  Sat Jan 22 2011 05:53

LANG_UK.txt
I. 22/01 05:54:01.    "ddd11" (ddd11.db)  ??? 22 ??? 2011 05:54
I. 22/01 05:54:01.    "ddd11" (ddd11.db)  ??? 22 ??? 2011 05:54

LANG_ZH.txt
I. 01/22 05:54:06? Sat Jan 22 2011 05:54  "ddd11" (ddd11.db)
I. 01/22 05:54:06? Sat Jan 22 2011 05:54  "ddd11" (ddd11.db) 
VolkerBarth
Contributor
0 Kudos

BTW, that doesn't answer the title question, but I hope it satisfies the "...IF I knew" part:)

graeme_perrow
Advisor
Advisor

Yep, "Checkpoints" is the first German word I learned after "der Lippenstift", though I don't use either one all that often. 🙂

Breck_Carter
Participant
0 Kudos

@Volker: It doesn't answer the title question? I thought it did... unless "Start des Checkpoints..." isn't German 🙂

Breck_Carter
Participant

@Graeme: That sounds pornografisch 🙂

johnsmirnios
Advisor
Advisor

Server messages are written to the console log file in OS language & OS character set. Characters in some languages are not representable in some character sets. Fetching messages from the server via sa_server_messages() will also pass the strings through a translation to database charset then to client charset. Parsing messages in multiple languages and character sets will be very, very painful.

VolkerBarth
Contributor
0 Kudos

@Breck: Interestingly enough, the really well-done German doc setup doesn't have a translation for "Checkpoint", so, yes, Graeme is right, it's an German word, obviously ... cf. http://dcx.sybase.com/index.html#1200de/dbreference/checkpoint-statement.html. It's nice that SQLA helps me understanding my native language better:)

VolkerBarth
Contributor
0 Kudos

@Breck: According to the timestamps, the German version is the fastest w.r.t. checkpointing - now that's OK with me:)

Under Russian Windows (SA10.0.1.4157 on WinXP SP3 Prof Rus), it is perfectly readable as follows:

I. 23/01 00:08:13. Запуск контрольной точки "trade" (trade.db) в Вс 23 Янв 2011 00:08 I. 23/01 00:08:13. Завершение контрольной точки "trade" (trade.db) в Вс 23 Янв 2011 00:08

(not that it makes sense for those who does not know Russian :))

Answers (1)

Answers (1)

johnsmirnios
Advisor
Advisor

Would watching for increments in db_property('Chkpt') work for you or are you parsing the messages as part of some other analysis too?

Breck_Carter
Participant
0 Kudos

Oops, I forgot about that property 🙂 What I am watching for is a checkpoint that starts but never ends, where the definition of "never" is to be determined. Sooo, db_property ( 'chkpt' ) won't help because it treats a checkpoint as an instant-in-time event... it doesn't matter if it's set at the start, middle or end of a checkpoint, I need both start and end.