Problem in joining hindi string in attribute table from excel sheet using ArcPy

580
1
06-11-2020 09:23 AM
PratyakshVijay
New Contributor

Hi,

I am trying to join excel sheet to shapefile attribute table using ArcPy, in the excel sheet there is a column which contains long hindi string. The maximum length of a text in attribute table is 254 but the hindi string is not joining with 254 characters instead the attribute table store only 107 characters approx.

When trying with english it store 254 characters.

 

 This is the Excel sheet containing a long hindi string.

This is the attribute table after joining the excel sheet like this it is not storing with max length 254 characters, it is only storing 107 characters. 

How to do it please help.

Thank you!

0 Kudos
1 Reply
DanPatterson
MVP Esteemed Contributor

I would try joining to a geodatabase featureclass or table.  A shapefile predates how unicode character counts are treated.


... sort of retired...