Just unsure regarding which data type can store data such as multiple language codes e.g. English:EN, Chinese:ZH, Malay:MS and even more in such a format(EN,ZH,MS), is LONGVARCHAR an option???

You need to use VARCHAR2.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.