Daniel Hwang

스스로 해보기 하는 중 질문입니다.

아 블로그 정오표에 다 해놓으셨넹 ㅎㅎ;

에러에 대한 질문입니다.

아 이거 find()가 아니라 findOne() 해야되네유~! 제로초님 이거 소스 수정하실 때 참고하세유ㅎ

KY lee님 이거 어떻게 해결하셨나요..?
저도 똑같은 에러인데 잘 안되네요ㅠ

<pre class="language-markup"><code> { Error: Incorrect string value: '\xEB\x90\x98\xEB\x9E\x8D' for column 'comment' at row 1
 at Packet.asError (D:\tutorials\nodejs_TextBook_zerocho\lecture\learn-sequelize\node_modules\mysql2\lib\packets\packet.js:708:17)
 at Execute.execute (D:\tutorials\nodejs_TextBook_zerocho\lecture\learn-sequelize\node_modules\mysql2\lib\commands\command.js:28:26)
 at Connection.handlePacket (D:\tutorials\nodejs_TextBook_zerocho\lecture\learn-sequelize\node_modules\mysql2\lib\connection.js:408:32)
 at PacketParser.Connection.packetParser.p [as onPacket] (D:\tutorials\nodejs_TextBook_zerocho\lecture\learn-sequelize\node_modules\mysql2\lib\connection.js:70:12)
 at PacketParser.executeStart (D:\tutorials\nodejs_TextBook_zerocho\lecture\learn-sequelize\node_modules\mysql2\lib\packet_parser.js:75:16)
 at Socket.Connection.stream.on.data (D:\tutorials\nodejs_TextBook_zerocho\lecture\learn-sequelize\node_modules\mysql2\lib\connection.js:77:25)
 at Socket.emit (events.js:198:13)
 at addChunk (_stream_readable.js:288:12)
 at readableAddChunk (_stream_readable.js:269:11)
 at readableAddChunk (_stream_readable.js:269:11)
 at Socket.Readable.push (_stream_readable.js:224:10)
 at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
 code: 'ER_TRUNCATED_WRONG_VALUE_FOR_FIELD',
 errno: 1366,
 sqlState: 'HY000',
 sqlMessage:
 'Incorrect string value: \'\\xEB\\x90\\x98\\xEB\\x9E\\x8D\' for column \'comment\' at row 1',
 sql:
 'INSERT INTO `comments` (`id`,`comment`,`created_at`,`commenter`) VALUES (DEFAULT,?,now(),?);',
 parameters: [ '되랍', '1' ] },
 sql:
 'INSERT INTO `comments` (`id`,`comment`,`created_at`,`commenter`) VALUES (DEFAULT,?,now(),?);',
 parameters: [ '되랍', '1' ] }
POST /comments 500 111.967 ms - 1639</code></pre>

Daniel Hwang

Posts