아래가.. 제 서버 설정인데.. utf8 설치시.. 한글이 깨져 보입니다. 정보

아래가.. 제 서버 설정인데.. utf8 설치시.. 한글이 깨져 보입니다.

장한솔 자기소개 아이디로 검색 회원게시물 (210.♡.♡.253)
2007.05.27 13:23:49
8,263

본문

localhost

서버 버전: 5.0.27-standard
Protocol version: 10
서버: Localhost via UNIX socket
사용자: shineworld@localhost
MySQL 문자셋: UTF-8 Unicode (utf8)
MySQL connection collation: Collation armscii8_bin armscii8_general_ci ascii_bin ascii_general_ci big5_bin big5_chinese_ci binary cp1250_bin cp1250_croatian_ci cp1250_czech_cs cp1250_general_ci cp1251_bin cp1251_bulgarian_ci cp1251_general_ci cp1251_general_cs cp1251_ukrainian_ci cp1256_bin cp1256_general_ci cp1257_bin cp1257_general_ci cp1257_lithuanian_ci cp850_bin cp850_general_ci cp852_bin cp852_general_ci cp866_bin cp866_general_ci cp932_bin cp932_japanese_ci dec8_bin dec8_swedish_ci eucjpms_bin eucjpms_japanese_ci euckr_bin euckr_korean_ci gb2312_bin gb2312_chinese_ci gbk_bin gbk_chinese_ci geostd8_bin geostd8_general_ci greek_bin greek_general_ci hebrew_bin hebrew_general_ci hp8_bin hp8_english_ci keybcs2_bin keybcs2_general_ci koi8r_bin koi8r_general_ci koi8u_bin koi8u_general_ci latin1_bin latin1_danish_ci latin1_general_ci latin1_general_cs latin1_german1_ci latin1_german2_ci latin1_spanish_ci latin1_swedish_ci latin2_bin latin2_croatian_ci latin2_czech_cs latin2_general_ci latin2_hungarian_ci latin5_bin latin5_turkish_ci latin7_bin latin7_estonian_cs latin7_general_ci latin7_general_cs macce_bin macce_general_ci macroman_bin macroman_general_ci sjis_bin sjis_japanese_ci swe7_bin swe7_swedish_ci tis620_bin tis620_thai_ci ucs2_bin ucs2_czech_ci ucs2_danish_ci ucs2_esperanto_ci ucs2_estonian_ci ucs2_general_ci ucs2_hungarian_ci ucs2_icelandic_ci ucs2_latvian_ci ucs2_lithuanian_ci ucs2_persian_ci ucs2_polish_ci ucs2_roman_ci ucs2_romanian_ci ucs2_slovak_ci ucs2_slovenian_ci ucs2_spanish2_ci ucs2_spanish_ci ucs2_swedish_ci ucs2_turkish_ci ucs2_unicode_ci ujis_bin ujis_japanese_ci utf8_bin utf8_czech_ci utf8_danish_ci utf8_esperanto_ci utf8_estonian_ci utf8_general_ci utf8_hungarian_ci utf8_icelandic_ci utf8_latvian_ci utf8_lithuanian_ci utf8_persian_ci utf8_polish_ci utf8_roman_ci utf8_romanian_ci utf8_slovak_ci utf8_slovenian_ci utf8_spanish2_ci utf8_spanish_ci utf8_swedish_ci utf8_turkish_ci utf8_unicode_ci
새 데이터베이스 만들기:
권한 없음

phpMyAdmin - 2.9.2

MySQL client version: 5.0.27
Used PHP extensions: mysql

테이블	실행	레코드수	종류	Collation
CHARACTER_SETS		36	View	utf8_general_ci
COLLATIONS		126	View	utf8_general_ci
COLLATION_CHARACTER_SET_APPLICABILITY		126	View	utf8_general_ci
COLUMNS		1,191	View	utf8_general_ci
COLUMN_PRIVILEGES		0	View	utf8_general_ci
KEY_COLUMN_USAGE		123	View	utf8_general_ci
ROUTINES		0	View	utf8_general_ci
SCHEMATA		2	View	utf8_general_ci
SCHEMA_PRIVILEGES		10	View	utf8_general_ci
STATISTICS		336	View	utf8_general_ci
TABLES		109	View	utf8_general_ci
TABLE_CONSTRAINTS		100	View	utf8_general_ci
TABLE_PRIVILEGES		0	View	utf8_general_ci
TRIGGERS		0	View	utf8_general_ci
USER_PRIVILEGES		1	View	utf8_general_ci
VIEWS		0	View	utf8_general_ci
테이블 16 개	계	2,160	MyISAM	utf8_general_ci

서버의 환경설정

변수	세션 값 / Global value
auto increment increment	1
auto increment offset	1
automatic sp privileges	ON
back log	50
basedir	/
binlog cache size	32,768
bulk insert buffer size	8,388,608
character set client	utf8
(Global value)	euckr
character set connection	utf8
(Global value)	euckr
character set database	euckr
character set filesystem	binary
character set results	utf8
(Global value)	euckr
character set server	euckr
character set system	utf8
character sets dir	/usr/share/mysql/charsets/
collation connection	utf8_unicode_ci
(Global value)	euckr_korean_ci
collation database	euckr_korean_ci
collation server	euckr_korean_ci
completion type	0
concurrent insert	1
connect timeout	5
datadir	/var/lib/mysql/
date format	%Y-%m-%d
datetime format	%Y-%m-%d %H:%i:%s
default week format	0
delay key write	ON
delayed insert limit	100
delayed insert timeout	300
delayed queue size	1,000
div precision increment	4
engine condition pushdown	OFF
expire logs days	0
flush	OFF
flush time	0
ft boolean syntax	+ -><()~*:""&\|
ft max word len	84
ft min word len	4
ft query expansion limit	20
ft stopword file	(built-in)
group concat max len	1,024
have archive	YES
have bdb	NO
have blackhole engine	NO
have compress	YES
have crypt	YES
have csv	NO
have dynamic loading	YES
have example engine	NO
have federated engine	NO
have geometry	YES
have innodb	DISABLED
have isam	NO
have merge engine	YES
have ndbcluster	NO
have openssl	NO
have query cache	YES
have raid	NO
have rtree keys	YES
have symlink	YES
init connect	set names euckr
init file
init slave
innodb additional mem pool size	1,048,576
innodb autoextend increment	8
innodb buffer pool awe mem mb	0
innodb buffer pool size	8,388,608
innodb checksums	ON
innodb commit concurrency	0
innodb concurrency tickets	500
innodb data file path
innodb data home dir
innodb doublewrite	ON
innodb fast shutdown	1
innodb file io threads	4
innodb file per table	OFF
innodb flush log at trx commit	1
innodb flush method
innodb force recovery	0
innodb lock wait timeout	50
innodb locks unsafe for binlog	OFF
innodb log arch dir
innodb log archive	OFF
innodb log buffer size	1,048,576
innodb log file size	5,242,880
innodb log files in group	2
innodb log group home dir
innodb max dirty pages pct	90
innodb max purge lag	0
innodb mirrored log groups	1
innodb open files	300
innodb support xa	ON
innodb sync spin loops	20
innodb table locks	ON
innodb thread concurrency	8
innodb thread sleep delay	10,000
interactive timeout	28,800
join buffer size	131,072
key buffer size	8,388,600
key cache age threshold	300
key cache block size	1,024
key cache division limit	100
language	/usr/share/mysql/korean/
large files support	ON
large page size	0
large pages	OFF
lc time names	en_US
license	GPL
local infile	ON
locked in memory	OFF
log	OFF
log bin	OFF
log bin trust function creators	OFF
log error
log queries not using indexes	OFF
log slave updates	OFF
log slow queries	OFF
log warnings	1
long query time	10
low priority updates	OFF
lower case file system	OFF
lower case table names	0
max allowed packet	1,048,576
max binlog cache size	4,294,967,295
max binlog size	1,073,741,824
max connect errors	10
max connections	100
max delayed threads	20
max error count	64
max heap table size	16,777,216
max insert delayed threads	20
max join size	18446744073709551615
max length for sort data	1,024
max prepared stmt count	16,382
max relay log size	0
max seeks for key	4,294,967,295
max sort length	1,024
max sp recursion depth	0
max tmp tables	32
max user connections	0
max write lock count	4,294,967,295
multi range count	256
myisam data pointer size	6
myisam max sort file size	2,147,483,647
myisam recover options	OFF
myisam repair threads	1
myisam sort buffer size	8,388,608
myisam stats method	nulls_unequal
net buffer length	16,384
net read timeout	30
net retry count	10
net write timeout	60
new	OFF
old passwords	ON
open files limit	1,024
optimizer prune level	1
optimizer search depth	62
pid file	/var/lib/mysql/h11.teamjang.com.pid
port	3,306
preload buffer size	32,768
prepared stmt count	0
protocol version	10
query alloc block size	8,192
query cache limit	1,048,576
query cache min res unit	4,096
query cache size	0
query cache type	ON
query cache wlock invalidate	OFF
query prealloc size	8,192
range alloc block size	2,048
read buffer size	131,072
read only	OFF
read rnd buffer size	262,144
relay log purge	ON
relay log space limit	0
rpl recovery rank	0
secure auth	OFF
server id	0
skip external locking	ON
skip networking	OFF
skip show database	OFF
slave compressed protocol	OFF
slave load tmpdir	/tmp/
slave net timeout	3,600
slave skip errors	OFF
slave transaction retries	10
slow launch time	2
socket	/var/lib/mysql/mysql.sock
sort buffer size	2,097,144
sql big selects	ON
sql mode
sql notes	ON
sql warnings	OFF
ssl ca
ssl capath
ssl cert
ssl cipher
ssl key
storage engine	MyISAM
sync binlog	0
sync frm	ON
system time zone	KST
table cache	64
table lock wait timeout	50
table type	MyISAM
thread cache size	0
thread stack	196,608
time format	%H:%i:%s
time zone	SYSTEM
timed mutexes	OFF
tmp table size	33,554,432
tmpdir	/tmp/
transaction alloc block size	8,192
transaction prealloc size	4,096
tx isolation	REPEATABLE-READ
updatable views with limit	YES
version	5.0.27-standard
version comment	MySQL Community Edition - Standard (GPL)
version compile machine	i686
version compile os	pc-linux-gnu
wait timeout	28,800

위에가 제 서버 설정 내용 입니다.

그누보드 utf8 설치시 문자셋이 깨지는 원인을 파악해 주시면 감사 하겠습니다.

음 타사이트.. 랑 비교해 본 결과.. 환경 설정 부분이-

이 서버 에선.. 그누보드 utf8 설치 되더군요-.-

Variable_name	Value
character_set_client	utf8
character_set_connection	utf8
character_set_database	utf8
character_set_results	utf8
character_set_server	utf8
character_set_system	utf8
collation_connection	utf8_general_ci
collation_database	utf8_general_ci
collation_server	utf8_general_ci

로 설정되 있군요.

제 서버랑.. 6군데가.. 설정이 틀리던데.. 환결설정 값 때문일가요??

댓글 4개

PhotoFly 홈페이지 자기소개 아이디로 검색 회원게시물

홈페이지 자기소개 아이디로 검색 회원게시물

(218.♡.♡.37)

07.05.27 13:38:12

1. httpd.conf 에서 기본언어설정안함

# AddDefaultCharset UTF-8

2. php.ini 에서 기본언어설정안함

; default_charset = "iso-8859-1"
; default_charset = "utf-8"

3. my.cnf 에서 캐릭터셋 수정

[client]
#password = your_password
default-character-set=utf8

[mysqld]
init_connect=SET collation_connection = utf8_general_ci
init_connect=SET NAMES utf8
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci

[mysql]
default-character-set=utf8
==================================================
위 상태에서 아래 두가지 버전모두 운영이 가능합니다.

그누보드4 UTF-8 = 한글 입출력
그누보드4 EUC-KR = 한글 정상 입출력
==================================================