Tibero5 character set º¯°æ¹æ¹ý
#»ó¼¼Áú¹®
select * from _dd_props;
NLS_CHARACTERSET MSWIN949
NLS_NCHAR_CHARACTERSET UTF8
À§¿Í °°ÀÌ DB Character Set Á¶È¸ ½Ã MSWIN949·Î ¼³Á¤µÇ¾îÀÖ½À´Ï´Ù.
UTF8·Î º¯°æÇÏ°í ½Í½À´Ï´Ù.
# ´äº¯
1. ij¸¯ÅÍ ¼ÂÀ» º¯°æÇϱâ À§Çؼ´Â DB¸¦ À籸¼º ÇØ¾ß ÇÕ´Ï´Ù.
2. tbexport·Î ½ºÅ°¸¶ °´Ã¼¸¦ ¹é¾÷ÇÕ´Ï´Ù.
3. ±â¼úÁö½Ä¸Þ´º¿¡ ÀÖ´Â ¼³Ä¡ °¡À̵带 ÂüÁ¶ÇÏ¿© µ¥ÀÌÅÍ º£À̽º »ý¼º ´Ü°èºÎÅÍ ¼³Ä¡ È®Àδܰè±îÁö ÀÛ¾÷ ¼öÇàÇÕ´Ï´Ù.
(µ¥ÀÌÅÍ º£À̽º »ý¼º½Ã Character Set ¼³Á¤ °ªÀ» ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.)
4. tbimport ·Î ExportÇÑ ½ºÅ°¸¶ °´Ã¼¸¦ ´Ù½Ã DB¿¡ ÀúÀåÇÕ´Ï´Ù.
..tbexport·Î ¹é¾÷ÇÑ ´ÙÀ½¿¡ µ¥ÀÌÅͺ£À̽º »ý¼º¸¦ ´Ù½ÃÇÏ°í tbimport·Î ´Ù½Ã DB¿¡ ÀúÀåÇؾßÇÔ...
tablespace »ý¼º½Ã À¯ÀÇ»çÇ×(¸Å¿ìÁß¿ä.......)
Ãâó: https://kjh0623dev.tistory.com/13?category=609911 [KJHÀÇ °³¹ßºí·Î±×]