Special Charecter in Navision 3.6 on SQL

lakshmivalluru
lakshmivalluru Member Posts: 168
edited 2004-07-30 in Navision Attain
Navision is not recognising £ symbol. its replacing it with a special charecter something like 'oe'. Any ideas y???? te pagecode and local setings are fine.
LR

Comments

  • facade
    facade Member Posts: 57
    lakshmivalluru wrote:
    te pagecode and local setings are fine.
    Are you sure? :lol: :P
  • lakshmivalluru
    lakshmivalluru Member Posts: 168
    s dear i am 100% sure. i didnt menton its on one of our clients database.after they run the ALTER comand in Query Analyser the navison converted £ symbol to a funny looking charecter.

    If anybody had similar kind of problem and sorted it then please share.
    LR
  • Afonso
    Afonso Member Posts: 27
    Hello,

    If you can tell your government to join Euro coin you'll have the problem solved...

    Now, without jokes, have you tried the codeunit 'ASCii <-> Ansii' to export the special caracters? I think is available on the dowload section of mibuso.

    Hope this helps,

    Afonso

Categories