Is the a character limit for the custom prompts creation？

Yes, each prompt has a limit of 4,000 characters. 

If you enter more than 4,000 characters, any text beyond it will not be saved.