Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 22nd April 2014, 23:02
eric.dizon's Avatar
eric.dizon eric.dizon is offline
Senior Member
 
Join Date: Feb 2012
Posts: 151
eric.dizon is on a distinguished road
Baan: ERP LN - DB: MS SQL - OS: 2003
T-SQL way to retrieve Chinese text
Baan: Other/Unknown
C/S: None/Unknown

I've created a T-SQL function/stored procedure on how to retrieve a value of a text in the tttxt010 table. The issue I have right now is there a way to retrieve a text value that is in Chinese character using t-sql only?

My function works fine when fetching English text, I get this value in SSL Management Server Studio when I use for Chinese encoded text

This is what I get from the query below... How make it show properly in Chinese ?
›½©ê›¾£Ì›½Ì¯›½¢›½¤›¾žæ›½õÙ›½®¨›½À›½œÈ›½žÍ›½þþŸ

SELECT @txt_content = ISNULL(cast(c.t_text as varchar(500)),'')
FROM [erplndb].[dbo].[ttttxt010600] c
WHERE c.t_ctxt = @txt_id and c.t_clan = @txt_lang and c.t_seqe = 1;
Reply With Quote
  #2  
Old 23rd April 2014, 10:28
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,286
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi,

It will be better to post these kind of queries in Microsoft Forum's. You will get a quick and precise answer over there.

I found a relevant post. You can check it:-

http://social.msdn.microsoft.com/For...um=transactsql

May be you will need to change some settings from your Control Panel to support other languages.

Also, there are a lot of related threads discussing the same. Google it!
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 23rd April 2014, 21:35
eric.dizon's Avatar
eric.dizon eric.dizon is offline
Senior Member
 
Join Date: Feb 2012
Posts: 151
eric.dizon is on a distinguished road
Baan: ERP LN - DB: MS SQL - OS: 2003
Hi bhushanchanda,

It makes sense to post this in a MS site at first glance, but the question I am trying to ask really when I look at the [tttxt010] with binary value of listed below. Is Baan doing something different on what is saved on the database level? I have read about TSS Encoding and UTF-8 but if I am using Baan tools and simply would to convert what Baan saved as a Chinese text value. Is there a way to decode what is saved in the database level back to Chinese text?

0x9BBDA9EA9BBEA3CC9BBDCCAF9BBDA2EC9BBD9DA49BBE9EE69BBDF5D99BBDAEA89BBD9DC09BBD9CC89BBD9ECD9BBDFEEE9BBFFE9F0A20202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Programming Question mr_suleyman Tools Development 37 11th November 2016 08:14
How to retrieve text data from Oracle database? Grace Cheong Tools Development 2 30th November 2011 01:54
Strange error while importing tables: Can not create index 9999 eppesuiG Tools Administration & Installation 8 17th March 2008 04:35


All times are GMT +2. The time now is 02:38.


©2001-2017 - Baanboard.com - Baanforums.com