# DB\_OUTPUT\_TABLE not support unicode field name

**URL:** <https://forum.cloverdx.com/t/db-output-table-not-support-unicode-field-name/486>\
**Category:** CloverDX Platform\
**Created:** [March 18, 2009, 12:00am UTC](https://forum.cloverdx.com/t/db-output-table-not-support-unicode-field-name/486 "2009-03-18T00:00:00Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![hwhwhw](https://avatars.discourse-cdn.com/v4/letter/h/9d8465/32.png) [@hwhwhw](https://forum.cloverdx.com/u/hwhwhw)\
**Post date:** [March 18, 2009, 12:00am UTC](https://forum.cloverdx.com/t/db-output-table-not-support-unicode-field-name/486/1 "2009-03-18T00:00:00Z")

</div>

===============================================

a.fmt

\<?xml version="1.0" encoding="gb2312"?\> 

=====================================  
ERROR [WatchDog] - Graph execution finished with error  
ERROR [WatchDog] - Node DB\_OUTPUT\_TABLE\_0 finished with status: ERROR caused by: Maximum # of errors exceeded when inserting record. Exeption thrown by: insert into t1 (c2) values ($名称). Message: Parameter index out of range (1 \> number of parameters, which is 0). with field 名称 caused by: java.sql.SQLException: Parameter index out of range (1 \> number of parameters, which is 0). with field 名称  
DEBUG [WatchDog] - Node DB\_OUTPUT\_TABLE\_0 error details:  
org.jetel.exception.JetelException: Maximum # of errors exceeded when inserting record. Exeption thrown by: insert into t1 (c2) values ($名称). Message: Parameter index out of range (1 \> number of parameters, which is 0). with field 名称 caused by: java.sql.SQLException: Parameter index out of range (1 \> number of parameters, which is 0). with field 名称  
at org.jetel.component.DBOutputTable.runInNormalMode(DBOutputTable.java:654)  
at org.jetel.component.DBOutputTable.execute(DBOutputTable.java:573)  
at org.jetel.graph.Node.run(Node.java:379)  
at java.lang.Thread.run(Thread.java:595)  
Caused by: java.sql.SQLException: Parameter index out of range (1 \> number of parameters, which is 0). with field 名称  
at org.jetel.connection.jdbc.CopySQLData.jetel2sql(CopySQLData.java:167)  
at org.jetel.connection.jdbc.SQLCloverStatement.executeUpdate(SQLCloverStatement.java:305)  
at org.jetel.component.DBOutputTable.runInNormalMode(DBOutputTable.java:617)  
… 3 more

===============================================  
**The reason is that questions do not support unicode field name, can support? How to solve this.**

---

<div class="post-metadata">

**Author:** ![hwhwhw](https://avatars.discourse-cdn.com/v4/letter/h/9d8465/32.png) [@hwhwhw](https://forum.cloverdx.com/u/hwhwhw)\
**Post date:** [March 18, 2009, 9:20am UTC](https://forum.cloverdx.com/t/db-output-table-not-support-unicode-field-name/486/2 "2009-03-18T09:20:53Z")

</div>

Very much like to be able to support unicode field name encoding 🙂

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [March 18, 2009, 10:16am UTC](https://forum.cloverdx.com/t/db-output-table-not-support-unicode-field-name/486/3 "2009-03-18T10:16:19Z")

</div>

Hello, there is no problem with encoding here, but with the query that doesn’t have input parameters. Try to set query _insert into t1 (c2) values (?)_ with data flowing on the edge or execute this query by DBExecute component.

---

<div class="post-metadata">

**Author:** ![hwhwhw](https://avatars.discourse-cdn.com/v4/letter/h/9d8465/32.png) [@hwhwhw](https://forum.cloverdx.com/u/hwhwhw)\
**Post date:** [March 19, 2009, 3:23am UTC](https://forum.cloverdx.com/t/db-output-table-not-support-unicode-field-name/486/4 "2009-03-19T03:23:35Z")

</div>

**But the configuration has not changed, I used the English field names on the successful implementation can, please re-check.**  
===============================================

===============================================

a.fmt

\<?xml version="1.0" encoding="gb2312"?\> 

===============================================

**At present, only use the $ symbol can achieve very good demand for the following.**  
**And? Symbolic way Can not Satisfy.**  
**[http://forum.cloveretl.org/viewtopic.php?t=299](http://forum.cloveretl.org/viewtopic.php?t=299)**

---

<div class="post-metadata">

**Author:** ![hwhwhw](https://avatars.discourse-cdn.com/v4/letter/h/9d8465/32.png) [@hwhwhw](https://forum.cloverdx.com/u/hwhwhw)\
**Post date:** [March 19, 2009, 3:31am UTC](https://forum.cloverdx.com/t/db-output-table-not-support-unicode-field-name/486/5 "2009-03-19T03:31:35Z")

</div>

1. 

**AGGREGATE component** org.jetel.component.aggregate.AggregateMappingParser.java

1. 

org.jetel.metadata.DataRecordMetadata.java  
org.jetel.metadata.DataFieldMetadata.java  
org.jetel.util.string.StringUtils.java  
private final static String **OBJECT\_NAME\_PATTERN** = “[\_A-Za-z]+[\_A-Za-z0-9]\*”;

Did not consider the place a lot of unicode field name

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [March 19, 2009, 8:44am UTC](https://forum.cloverdx.com/t/db-output-table-not-support-unicode-field-name/486/6 "2009-03-19T08:44:38Z")

</div>

Yes, that’s true: only Latin letters and digits can be used in field name. Different chars could cause problems when moving graphs between computers.

---

<div class="post-metadata">

**Author:** ![hwhwhw](https://avatars.discourse-cdn.com/v4/letter/h/9d8465/32.png) [@hwhwhw](https://forum.cloverdx.com/u/hwhwhw)\
**Post date:** [March 19, 2009, 9:13am UTC](https://forum.cloverdx.com/t/db-output-table-not-support-unicode-field-name/486/7 "2009-03-19T09:13:07Z")

</div>

**Hope can be solved by modifying the questions below.**
