Issue in Inserting and recognizing Hungarian(Hungary) language

[piZviZ]

Hello LabVIEW Users,

I am working on the Hungarian language based application and having trouble in two characters which are not recognized by LabVIEW as well as SQL Server2008.

Characters are ő and ű.

For more information, l have attached document here which shows that how LabVIEW and database recognize it.

Thanks ...

[Bob_Schor]

I suspect this is a "Unicode in LabVIEW" issue.  If you do a Web search on this topic, you can see the current state of this issue.

Bob Schor

[alexderjuengere]

https://knowledge.ni.com/KnowledgeArticleDetails?id=kA00Z000000kJRNSA2&l=de-DE

[piZviZ]

I am able to show characters in LabVIEW but not able to show(log) it into SQL server database.

Please see the attached image for more information. 

[piZviZ]

But manually I can write those characters in database ,but can't write it through LabVIEW

[aptivo]

Have you tried to change ist to utf8 before writing it to the DB? If reading it from the DB you have to change it back. For conversion there is a hidden LV function. Have a closer look here:

https://forums.ni.com/t5/LabVIEW/undocumented-function-quot-text-to-utf-8-quot/m-p/1034616/highlight...

[alexderjuengere]

---

@aptivo wrote:

Have you tried to change ist to utf8 before writing it to the DB? If reading it from the DB you have to change it back. For conversion there is a hidden LV function. Have a closer look here:

https://forums.ni.com/t5/LabVIEW/undocumented-function-quot-text-to-utf-8-quot/m-p/1034616/highlight...

---

This is a cool function if you want to write special characters like Ő as an utf-8 string to a text-file

but does piZviZ's SQL 2008 database accept utf-8, or rather UTF-16 encoded strings?

[piZviZ]

Hi,

Can you upload same VI? I am not able to use snippet.

[aptivo]

Download is in the link I've sent.

A more detailed description can be found here: 

https://forums.ni.com/t5/Reference-Design-Content/LabVIEW-Unicode-Programming-Tools/ta-p/3493021

[alexderjuengere]

---

@aptivo wrote:

Download is in the link I've sent.

A more detailed description can be found here: 

https://forums.ni.com/t5/Reference-Design-Content/LabVIEW-Unicode-Programming-Tools/ta-p/3493021

---

the LabVIEW Unicode Programming Tools

are a different resource (in regards to undocumented function "text to utf-8").

You could use those Unicode Tools to write an utf-16 string to file via LabView.

also, its a good resource to learn about unicode-specific tidbits (that may bite you) like utf16-LE and BOM