LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Andrey Kateshov

I'm extracting data from MS SQL server using jdbc node. There are some column names which contain non-latin characters
which are in utf-8 codepage (I can read these well in BRDViewer when I set copepage for "string" type and metadata to
utf-8). However the very next node fails to recognize those columns that are not fully latin (all-latin column names work
perfectly well).

I have cp1251 (which is a proper encoding) set in Advanced preferences. Still for some strange reason in error log it
writes that "node charset is set to cp1252").

Please help

I attach the bug report to this post
Attachments:
BREProblemReport.zip

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: aorlovsky

Andrey,
The message in the error log will go away if you set the property ls.brain.node.characterSet = "windows-1251"

The filter in you sample graph will still fail. This is because some of your column names are unicode characters. It will work just fine in BRAIN if you use the "windows-1251" encoding for your column names. That is, column names must not be written to the brd using utf-8, but rather as Cyrillic characters in the windows-1251 codepage. If you make this change, you will also have to specify windows-1251 as the metadata codepage for the BrdViewer.

The rules for using Unicode in BRAIN are available in the BRAIN Release Notes.

It would be helpful if you could also attach a small sample db so we could reproduce your import step exactly.
Were you using BRAIN 4.1.4?

Best regards

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dvs79

It seems that I have a similar problem with import from CSV - cyrillic text isn't recognized correctly. I use a Delimited File node for this. What should I do to fix it?

Thanks!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

Have you followed the advice that Alex gave, above? You are going to want to change your codepage for BRE (advanced options in BRE), the server (server property given above), and BrdViewer (preferences), all to 1251, and it should work, I believe. If you want to post a sample of data that isn't working with a graph, that could help us troubleshoot, if this doesn't work.

Cheers
Rich