international characters in comment

[radioalarm]

Hi. I'm using v3.5.2.4 on Win2008/SQL2005. There's a problem with PC comment field and my native characters - only some of them are displayed correctly. This is from Lansweeper:

aceeišuužACEEIŠUUŽ

That's how it should look:

ąčęėįšųūžĄČĘĖĮŠŲŪŽ

[Hemoco]

Yes, it's a known problem.

Next version will have all fields unicode by default.

[Hemoco]

try the following sql code:

ALTER TABLE [tblOperatingsystem ALTER COLUMN Description nvarchar(500)
GO

[radioalarm]

Lansweeper wrote:
try the following sql code:

ALTER TABLE [tblOperatingsystem ALTER COLUMN Description nvarchar(500)
GO

Awesome! Now comments are displayed correctly.

The script didn't work though, it was complaining about indexes. But I've changed it through SQL GUI.

So the problem was non-unicode field type?

[radioalarm]

No, i'm looking at Description field, in tblOperatingsystem. I meant the comment in Windows "My computer" properties, not the custom comment in web interface.

[Hemoco]

The field you are referring to is "comments" in table "tblcompcustom" right?
It should be "ntext"

Are you running database/website/webbrowser on the same server?

[radioalarm]

Lansweeper wrote:
Are you running database/website/webbrowser on the same server?

Sorry, forgot to answer this. DB and site is on the same server. It doesn't matter if you use local or remote browser.

[radioalarm]

As far as I can see everything else is ok, at least in installed programs list.

I went to sql server and opened the table which contains comments. Tried to change it manually using the same string of characters, and it immediately was converted to the same result as displayed in web interface. Could this be a problem with column type or database properties?

[Hemoco]

I can't reproduce the problem, is the comment field the only field with this problem?