EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB37744: How to enclose double byte character (e.g. Korean) column name in a table by double quote(“”) in Teradata database?


Community Admin

• Strategy


Teradata database requires double byte character (e.g. Korean) column name in a table to be enclosed by double quote as syntax

Teradata database requires double byte character (e.g. Korean) column name in a table to be enclosed by double quote as syntax, as shown below:
 
Original column name in SQL statements:
 
Sql
select 지점코드 from CodeTable
 
Column name enclosed by double byte in SQL statements:
 
Sql
select "지점코드" from CodeTable
  
The follow steps explain how to enclose column by double quote in Strategy Tutorial project. 

  • Change Column Pattern from #0. as default to #0.”#1” for database instance at VLDB Properties > Tables > Column Pattern as shown below:
     
ka04W000000OhMKQA0_0EM440000002DYb.png
  •  
    NOTE: Restart Strategy Intelligence Server to make new VLDB settings take effect.
     
  • Run the report in SQL view, note that the column is enclosed by double quote, as shown below:
     
ka04W000000OhMKQA0_0EM440000002DYX.png
  •  
    The original SQL view of the report is as shown below:
     
ka04W000000OhMKQA0_0EM440000002DYU.png

 


Comment

0 comments

Details

Knowledge Article

Published:

May 24, 2017

Last Updated:

May 24, 2017